EXEC master..xp_cmdshell 'bcp "select * from dbname..tablename " queryout c:\DT.txt -c -Sservername -Usa -Ppassword'select left(A.name, 20) col, left(C.name,20) type, A.length from
syscolumns A left join sysobjects B
on A.id = B.id left join systypes C
on A.xtype = C.xtype
where B.name = 'yourtablename'sp_columns 'yourtablename'
syscolumns A left join sysobjects B
on A.id = B.id left join systypes C
on A.xtype = C.xtype
where B.name = 'yourtablename'sp_columns 'yourtablename'
exec master..xp_cmdshell 'bcp 库名..表名 out 路径\文件名.txt -c -t , -r /n -S服务器名 -U用户名 -P密码'
用法: C:\PROGRA~1\MICROS~4\80\TOOLS\BINN\BCP.EXE {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]
如何 才能得到 第一行是字段名 a1,a2,a3?
第二行以后是数据?格式为:a1,a2,a3
ww,ee,rr
tt,y,h
sd,c,c
是 f1,f2,f3我的 EXEC master..xp_cmdshell 'bcp "select col1 as f1,col2 as f2,col3 as f3 from dbname..tablename " queryout c:\DT.txt -t "," -c -Sservername -Usa -Ppassword'
如何 才能得到 第一行是字段名 f1,f2,f3?
第二行以后是数据?格式为:f1,f2,f3
ww,ee,rr
tt,y,h
sd,c,c
aa,bb
422315633322111,aa
121215121212111,cc
121154541512121,tt
111225563356663,dd用:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [test#txt]')