- 当前位置：首页 >IT科技 >Sybase ASE15中bcp实现有条件的导出表内数据
Sybase ASE15中bcp实现有条件的导出表内数据
发布时间：2025-11-05 05:33:36 来源：创站工坊 作者：人工智能
复制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.
IT资讯网益华科技亿华云源码库香港云服务器服务器租用IT技术网企商汇源码下载全栈开发益华IT技术论坛汇智坊益强科技亿华互联益强前沿资讯IT资讯网云站无忧亿华智造码上建站益强科技亿华科技技术快报智能时代科技前瞻益强编程堂益强IT技术网极客码头云智核益强数据堂益强资讯优选亿华灵动编程之道多维IT资讯益强编程舍益华科技亿华智慧云益华科技运维纵横思维库码力社益强智囊团亿华云益强智未来
- Copyright © 2025 Powered by Sybase ASE15中bcp实现有条件的导出表内数据,创站工坊 滇ICP备2023006006号-44sitemap