如果TOP 条数是变量,直接在TOP后加变量会报错。只有将变量用括号括起来即可。
1 DECLARE @LineCount INT =2 2 SELECT TOP (@LineCount*2) * FROM sys.tables AS t