十分郁闷的问题!!差点把电脑砸掉
set @sqlstr= 'select top '+@temp+ 'GoodRecordNumber from tb_GoodRecord order by GoodRecordID desc '
exec(@sqlstr)
除了以上的方法~还有其他的办法吗?用exec的话就取不到查询出来的值了!我现在想把查询出来的值拿来当条件使用?各位帮我解决解决问题吧!我差点没有把电脑砸了
[解决办法]
已pubs数据库的authors表为例
declare @num int
declare @sqlstr varchar(8000)
set @num=4
exec( 'select * into tablename from (select top '+@num+ ' * from authors order by city desc)t ')
select * from tablename
-----
672-71-3249YokomotoAkiko415 935-42283 Silver Ct.Walnut CreekCA945951
893-72-1158McBaddenHeather707 448-4982301 PutnamVacavilleCA956880
267-41-2394O 'LearyMichael408 286-242822 Cleveland Av. #14San JoseCA951281
486-29-1786LocksleyCharlene415 585-462018 Broadway Av.San FranciscoCA941301
