22,207
社区成员
发帖
与我相关
我的任务
分享
create proc scsp
(@i int)
as
begin
set nocount on
declare @sql varchar(6000)
select @sql='exec master..xp_cmdshell ''bcp "select cast([字段] as varchar(50))+' ' [字段名] from table1 where i='+cast(@i as varchar(5))
+' " queryout [导出路径]\'+cast(@i as varchar(5))+'.xls -c -q -S "[服务器名]" -U "[帐号]" -P "[密码]" -T '' '
exec(@sql)
end
create proc scsp
(@i int)
as
begin
set nocount on
declare @sql varchar(6000)
select @sql='exec master..xp_cmdshell ''bcp "select * from table1 where i='+cast(@i as varchar(5))
+' " queryout [导出路径]\'+cast(@i as varchar(5))+'.xls -c -q -S "[服务器名]" -U "[帐号]" -P "[密码]" -T '' '
exec(@sql)
end