create procedure Sql2Txt(@FilePath varchar(500))
as
begin
EXEC master..xp_cmdshell 'bcp "stueval2..result" out @FilePath -c -S (local) -U sa -P'
end
exec 'c:\123.txt'
as
begin
EXEC master..xp_cmdshell 'bcp "stueval2..result" out @FilePath -c -S (local) -U sa -P'
end
exec 'c:\123.txt'
导出文件直接
EXEC master..xp_cmdshell 'bcp 数据库名.dbo.person out D:\T111.txt -c -q -S"192.168.1.100" -U"sa" -P"12345"'