sqlserver 存储过程只需top+参数

DECLARE @sql NVARCHAR(MAX),@topcount INT
SET @topcount = 5
SET @sql = 'SELECT TOP ' + CAST(@topcount AS VARCHAR) + ' * FROM dbo.sysobjects'
EXEC sp_executesql @sql

原文地址:https://www.cnblogs.com/tc310/p/13300818.html