请教在存储过程中执行SQL,如何把多个结果放入定义的变量中?
declare @aaa int, @bbb char(80), @ccc datetime, @sqls nvarchar(4000)
set @sqls='select @aaa=aaa, @bbb=bbb, @ccc=ccc from tableName'
exec sp_executesql @sqls,N'@aaa int output, @bbb char(80) output, @ccc datetime', @aaa output, @bbb output, @ccc output
上述写法对不对?(或许select 后面还需加个 top 1)