--处理示例 use pubs go--存储过程 create proc test as select id,name from sysobjects go--将存储过程的结果保存了 csv 文件,SQL服务器登录用户为:sa,密码为空 declare @s varchar(8000) set @s='bcp "exec pubs..test" queryout "c:\'+convert(varchar,getdate(),112)+'.csv" /U"sa" /P"" /c' exec master..xp_cmdshell @s go--删除测试 drop proc test
use pubs
go--存储过程
create proc test
as
select id,name from sysobjects
go--将存储过程的结果保存了 csv 文件,SQL服务器登录用户为:sa,密码为空
declare @s varchar(8000)
set @s='bcp "exec pubs..test" queryout "c:\'+convert(varchar,getdate(),112)+'.csv" /U"sa" /P"" /c'
exec master..xp_cmdshell @s
go--删除测试
drop proc test
SQLState = 08001, NativeError = 14
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]无效的连接。
SQLState = 01000, NativeError = 14
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).
NULL