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'
...全文
1266打赏收藏
这个存储过程为什么执行后没有生成文件
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'