The following code works, but either of the commented lines produce a syntax error in my environment. When the code from the article is cut and pasted it produces the same error. Is there a configuration setting that allows this to work?

DECLARE @N INT

SET @N = 5

select TOP 5 * from table_name

--select TOP @N * FROM table_name

--select TOP (@N) * FROM table_name