字符串里变量用sp_executesqldeclare @result int,@sql nvarchar(100)--nvarcharset @result=29set @sql = N'select @result'exec sp_executesql @sql,N'@result int',@result
set @sql = 'select "@result"'