sql语句里怎么用变量呀

[wzhiyuan]

declare @pagesize int
set @pagesize = 10
select top @pagesize * from album
order by picid

这样怎么不对啊？

select top 10 * from album
order by picid 又可以 为什么呢？那我怎么写存储过程啊！

[邦迪代驾]

顶

[NinGoo]

采用变量需要使用动态SQL

declare @pagesize int
declare @sql varchar(1000)

set @pagesize = 10

set @sql='select top '+ @pagesize+'* from album order by picid'

exec (@sql)