变量未声明，不知道如何解决？？

[boygirlboy]

declare @sql varchar(5000),
@school_id int,
@send_msg int
set @school_id=1001
set @sql = 'select @send_msg=Send_Msg,@freeMessageCount=FreeMessageCount from ['+cast(@school_id as varchar)+'_User_Info] where ID=6'
exec(@sql)

服务器: 消息 137，级别 15，状态 1，行 1
必须声明变量 '@send_msg'。

[pbsql]

exec sp_executesql ...

[zjcxc]

declare @sql Nvarchar(4000),--改了定义
@school_id int,
@send_msg int
set @school_id=1001
set @sql = 'select @send_msg=Send_Msg,@freeMessageCount=FreeMessageCount from ['+cast(@school_id as varchar)+'_User_Info] where ID=6'
exec sp_executesql @sql
,N'@school_id int out,@send_msg int out'
,@school_id out,@send_msg out

[boygirlboy]

不行，问题依旧

[lzymagi]

在EXEC中变量要用+''@NAEM''+来括起来才行
你试试PRINT @SQL有没错