select 问题
declare @count int
set @count = 2
select top @count * from test
这句话为什么出错
[解决办法]
------------try-------------
declare @count int
set @count = 2
exec( 'select top '+@count+ ' * from test ')
[解决办法]
2005没问题
2000就会出错
declare @count int
set @count = 2
exec( 'select top '+ cast(@count as varchar) + ' * from test ')
[解决办法]
select top @count * from test
这个语句不能直接执行,要变成动态的sql执行
[解决办法]
declare @n int set @n=4
exec( 'select top '+ @n+ ' * from tb1 ')
[解决办法]
2005 top 可以带参
[解决办法]
动态的sql