Sybase ASE15中bcp实现有条件的导出表内数据
时间:2025-11-04 23:31:42 出处:域名阅读（143）
复制C:\Documents and Settings\Administrator>bcp master..sysobjects out sysobjects.tx t --initstring "select id,条件name,type from master..sysobjects where type=U " -c -Usa -P -Stest Starting copy... 163 rows copied. Clock Time (ms.): total = 16Avg = 0 (10187.50 rows per sec.) C:\Documents and Settings\Administrator>more sysobjects.txt sysobjects 1 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysindexes 2 1 S 0 97 0 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 syscolumns 3 1 S 0 97 0 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 systypes 4 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 syslogs 8 1 S 0 1 0 0 73728 Dec 2 2 009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 syspartitions 28 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysgams 14 1 S 0 1 0 0 73728 Dec 2 2 009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 systabstats 23 1 S 0 97 1 0 229888 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysusages 31 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysdatabases 30 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysdevices 35 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 ^C C:\Documents and Settings\Administrator> C:\Documents and Settings\Administrator>bcp master..sysobjects out sysobjects.tx t --initstring "select id,name,type from master..sysobjects where type=U " -c -Usa -P -Stest Starting copy... 163 rows copied. Clock Time (ms.): total = 16Avg = 0 (10187.50 rows per sec.) C:\Documents and Settings\Administrator>more sysobjects.txt sysobjects 1 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysindexes 2 1 S 0 97 0 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 syscolumns 3 1 S 0 97 0 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 systypes 4 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 syslogs 8 1 S 0 1 0 0 73728 Dec 2 2 009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 syspartitions 28 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysgams 14 1 S 0 1 0 0 73728 Dec 2 2 009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 systabstats 23 1 S 0 97 1 0 229888 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysusages 31 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysdatabases 30 1 S 0 97 2 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 sysdevices 35 1 S 0 97 1 0 229376 Dec 2 2009 6:58:34:590PM Dec 2 2009 6:58:34:590PM 0 0 0 0 0 0 0 0 1 0000000000000000 ^C C:\Documents and Settings\Administrator> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.
分享到：
温馨提示：以上内容和图片整理于网络，仅供参考，希望对您有帮助！如有侵权行为请联系删除！