27,582
社区成员




set rowcount N --取N条
seelct * from 表名
set rowcount 0
DECLARE @TOP VARCHAR(50),
@TABLE VARCHAR(100)
SELECT @TOP='4' --前4条记录
,@TABLE='tabeName'
EXEC('SELECT TOP '+ltrim(@TOP)+' * FROM '+@TABLE)
DECLARE @TOP VARCHAR(50),
@TABLE VARCHAR(100)
SELECT @TOP='4' --前4条记录
,@TABLE='tabeName'
EXEC('SELECT TOP '+@TOP+' * FROM '+@TABLE)
exec ('select top '+num +' * from tb')