select 问题

[happyie]

declare @count int
set @count = 2
select top @count * from test

这句话为什么出错

[leo_lesley]

------------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')

[leo_lesley]

select top @count * from test

这个语句不能直接执行，要变成动态的sql执行

[happyie]

declare @count int
set @count = 2

DECLARE csrCmd CURSOR LOCAL FOR
exec('select top '+ @count + ' * from test')
OPEN csrCmd
FETCH csrCmd INTO @filmid

我需要在存储过程中 ,好像这样还是不行

[wojila]

declare @n int set @n=4
exec('select top '+ @n+' * from tb1')

[mugua604]

2005 top 可以带参

[saiwong]

动态的sql

[areswang]

mark