记得上次提问,有人告诉我说Sql server 2005里面TOP后面可以跟变量
如
declare @num as int
set @num = 10
select top @num * from table结果我在2005里面一试,还是不行,欺骗我的感情啊~~~~
如
declare @num as int
set @num = 10
select top @num * from table结果我在2005里面一试,还是不行,欺骗我的感情啊~~~~
declare @sql varchar(200)
set @num = 10
set @sql = 'select top '+ cast(@num as char) + ' * from table'
exec(@sql)
set @num = 10
select top(@num) * from table
要加()的
set @num = 10
select top(@num) * from table
问题解决了,我还在想半天。呵呵