declare @temptbname varchar(99),
@database varchar(99),
@mbtbname varchar(99),
@sql varchar(8000),
@filename varchar(8000)
DECLARE @result int
set @sql = 'master..xp_cmdshell bcp '''+ @database + '..' +HuiZongTableName
+' in ' + @filename+ ' -c -U ' + usr + ' -P ' + psw + ''',NO_OUTPUT select @result';
exec @sql
@database varchar(99),
@mbtbname varchar(99),
@sql varchar(8000),
@filename varchar(8000)
DECLARE @result int
set @sql = 'master..xp_cmdshell bcp '''+ @database + '..' +HuiZongTableName
+' in ' + @filename+ ' -c -U ' + usr + ' -P ' + psw + ''',NO_OUTPUT select @result';
exec @sql
可以得到返回值的,语句最后有一条 select 语句select @result
最后 select @result ??@result 没见在哪里赋值呢 ??严重关注
insert into # exec(@sql)
select * from #