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