●[T-SQL] ストアドでBCP出力
declare
@cmdstr varchar(1000),
@ret int
set @cmdstr = 'bcp "select * from northwind.dbo.products " queryout c:\temp\products.txt -c -t "," -U sa -P pwd -o c:\temp\bcp.log'
exec @ret = master.dbo.xp_cmdshell @cmdstr
print 'ReturnValue:'+ Cast(@ret as varchar)
@cmdstr varchar(1000),
@ret int
set @cmdstr = 'bcp "select * from northwind.dbo.products " queryout c:\temp\products.txt -c -t "," -U sa -P pwd -o c:\temp\bcp.log'
exec @ret = master.dbo.xp_cmdshell @cmdstr
print 'ReturnValue:'+ Cast(@ret as varchar)