bcp能够实现按照条件导出表内数据

来源：互联网发布：发型设计软件破解版编辑：程序博客网时间：2024/05/01 07:49

要求是：导出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' orderby name " -c -Usa -P -StestStarting 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.txt233048835 HP_PAGENO_RANGE1065051799 IVCMPLX553049975 IVCON601050146 IVCPROP425049519 IVONEROW793050830 IVPARAM377049348 IVSCHM457049633 IVSCON937051343 IVSHARE889051172 IVSPROC649050317 IVSPROP1033051685 IVSRVR505049804 IVSSYN985051514 IVSTAT841051001 IVSTR697050488 IVSVIEW745050659 IVVCOL121048436 errorlog1337052768 ijdbc_function_escapes1093575903 jdbc_function_escapes265048949 lzflzf21572084 monCachePool2137055618 monCachedObject533573908 monCachedProcedures725574592 monCachedStatement1753054250 monDataCache2041055276 monDeadLock117572426 monDeviceIO1721054136 monEngine1977055048 monErrorLog85572312 monIOQueue661574364 monLicense2009055162 monLocks1945054934 monNetworkIO1881054706 monOpenDatabases53572198 monOpenObjectActivity629574250 monOpenPartitionActivity757574706 monPCIBridge821574934 monPCIEngine789574820 monPCISlots1785054364 monProcedureCache1817054478 monProcedureCacheMemoryUsage^C

转载：http://www.dbainfo.net/ase-15-bcp-out-table-by-conditions.htm

0 0