Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate] October 8, 2022 by Tarik Yes, in SQL Server 2005 it’s possible to use a variable in the top clause. select top (@top) * from tablename