应该是这条 select top 1 item from @dbname order by item desc 要使这条命令成立该怎么写?
exec('select top 1 item from '+@dbname+' order by item desc')
DECLARE @dbname nchar(10)set @dbname='data' --select top 1 @item=item from @dbname order by item desc set @item=(exec('select top 1 item from '+@dbname+' order by item desc') select @item
select top 1 item from @dbname order by item desc
要使这条命令成立该怎么写?
--select top 1 @item=item from @dbname order by item desc
set @item=(exec('select top 1 item from '+@dbname+' order by item desc')
select @item