exec ('select top '+ltrim(@count)+' * from [table]') 2000 top 后面不能直接跟变量
select top (@count) * from [table]
1. declare @count int declare @sql varchar(8000) set @count=20 set @sql='select top '+ltrim(@count)+' * from [table]' exec(@sql)2. declare @id int set @id=0 if @id=0 select * from [Table]
declare @count int
declare @sql varchar(8000)
set @count=20
set @sql='select top '+ltrim(@count)+' * from [table]'
exec(@sql)2.
declare @id int set @id=0
if @id=0
select * from [Table]