你试一下,应该没有问题的
declare @num int,
@sqls nvarchar(4000)
set @sqls='select top 1 @a = '+@name + ' from sanqu order by 日期,时间 desc'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
declare @num int,
@sqls nvarchar(4000)
set @sqls='select top 1 @a = '+@name + ' from sanqu order by 日期,时间 desc'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
declare @num int,
@sqls nvarchar(4000)
set @sqls='select top 1 @a = '+@name + ' from sanqu order by 日期,时间 desc'
exec sp_executesql @sqls,N'@a int output',@num output
select @num