关于exec(...) 执行时，总是报错呢？帮忙看下哦
declare @count int
declare @table varchar(50)
set @table = 'webgame_sys_user '
exec( 'SELECT '+@count+ ' = COUNT(user_id) FROM '+ @table)
print @count
提示=号附近有语法错误 ？
[解决办法]
declare @count int
declare @table varchar(50)
declare @sql nvarchar(2000)
set @table = 'webgame_sys_user '
set @sql = 'SELECT @count = COUNT(user_id) FROM '+ @table
EXEC sp_executesql @sql,N '@count int output ',@count output
print @count
[解决办法]
declare @count int, @sql Nvarchar(1000)
declare @table varchar(50)
set @table = 'webgame_sys_user '
set @sql = ' SELECT @count = COUNT(user_id) FROM '+ @table
exec sp_executesql @sql, N '@count int output ', @count output
print @count
[解决办法]
declare @count int, @sql nvarchar(4000)
declare @table varchar(50)
set @table = 'webgame_sys_user '
set @sql= 'select @a=count(user_id) from ' + @table
exec sp_executesql @sql,N '@a int output ',@count output
select @count
[解决办法]
用sp_executesql 得到返回参数
