本文介绍如何使用bcp命令从sysobjects表中导出类型为'U'的用户表的id和name两列数据。通过具体实例展示了bcp命令的使用方法及其输出结果。
要求是：导出sysobjects表中用户表的id和name两列数据。bcp命令语句如下：
bcp #temptbl out sysobjects_id_name.txt --initstring "select id,name into #temptbl from sysobjects where type='U' order by name " -c -Usa -P -Stest
效果如下：
C:\Documents and Settings\Administrator>bcp #temptbl out sysobjects_id_name.txt --initstring "select id,name into #temptbl from sysobjects where type='U' order by name " -c -Usa -P -Stest Starting copy... 87 rows copied. Clock Time (ms.): total = 16 Avg = 0 (5437.50 rows per sec.) C:\Documents and Settings\Administrator>more sysobject_id_name.txt 233048835 HP_PAGENO_RANGE 1065051799 IVCMPLX 553049975 IVCON 601050146 IVCPROP 425049519 IVONEROW 793050830 IVPARAM 377049348 IVSCHM 457049633 IVSCON 937051343 IVSHARE 889051172 IVSPROC 649050317 IVSPROP 1033051685 IVSRVR 505049804 IVSSYN 985051514 IVSTAT 841051001 IVSTR 697050488 IVSVIEW 745050659 IVVCOL 121048436 errorlog 1337052768 ijdbc_function_escapes 1093575903 jdbc_function_escapes 265048949 lzflzf 21572084 monCachePool 2137055618 monCachedObject 533573908 monCachedProcedures 725574592 monCachedStatement 1753054250 monDataCache 2041055276 monDeadLock 117572426 monDeviceIO 1721054136 monEngine 1977055048 monErrorLog 85572312 monIOQueue 661574364 monLicense 2009055162 monLocks 1945054934 monNetworkIO 1881054706 monOpenDatabases 53572198 monOpenObjectActivity 629574250 monOpenPartitionActivity 757574706 monPCIBridge 821574934 monPCIEngine 789574820 monPCISlots 1785054364 monProcedureCache 1817054478 monProcedureCacheMemoryUsage ^C
转载：http://www.dbainfo.net/ase-15-bcp-out-table-by-conditions.htm
扫一扫
786
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
