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

posted @ 2020-07-14 18:34  tc310  阅读(325)  评论(0编辑  收藏  举报