select top 10 * from 表
如果是个变量
DECLARE @n INT,@str NVARCHAR(200)
SET @n = 10
SET @str =''
SET @str ='select top '+CAST(@n AS NVARCHAR(5))+' FROM 表'
EXEC(@str)
如果是个变量
DECLARE @n INT,@str NVARCHAR(200)
SET @n = 10
SET @str =''
SET @str ='select top '+CAST(@n AS NVARCHAR(5))+' FROM 表'
EXEC(@str)
如果是个变量
DECLARE @n INT,@str NVARCHAR(200)
SET @n = 10
SET @str =''
SET @str ='select top '+CAST(@n AS NVARCHAR(5))+' * FROM 表'
EXEC(@str)
set @n=10set @sql='select * top '+cast(@n as varchar(10))+' from xx'
exec(@sql)