如何使用动态变量设置SQL Server中要返回的行数?以下语法在SQL Server 2005+中无效:
DECLARE @count int
SET @count = 20
SELECT TOP @count * FROM SomeTable
如何使用动态变量设置SQL Server中要返回的行数?以下语法在SQL Server 2005+中无效:
DECLARE @count int
SET @count = 20
SELECT TOP @count * FROM SomeTable
SELECT TOP (@count) * FROM SomeTable
这只适用于SQL 2005+