引自:http://community.csdn.net/Expert/topic/3717/3717728.xml?temp=.3920404
CREATE procedure File2Table
@servername varchar(200),
@username varchar(200),
@password varchar(200),
@tbname varchar(500),
@filename varchar(1000),
@isout bit
as
declare @sql varchar(8000)
if @tbname like '%.%.%'
begin
set @sql='master..xp_cmdshell ''bcp '+@tbname+' '+case when @isout=1 then 'out' else 'in' end+' "'+@filename+'" -w -S "'+@servername+'" -U "'+@username+'" -P"'+@password+'"'''
select @sql
exec(@sql)
end
执行
exec File2Table @servername='MYTOMATO',@username='sa',@password='',@tbname='pubs.dbo.employee',@filename='c:/zx.txt',@isout='1'
结果显示:
master..xp_cmdshell 'bcp pubs.dbo.employee out "c:/zx.txt" -w -S "127.0.0.1" -U "sa" -P"000000"'
NULL
开始复制...
NULL
已复制了 43 行。
数据包的大小(字节): 4096
时钟时间(毫秒): 共 94
NULL