SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT TOP 1 'abc'

(No column name)

abc

DECLARE @MemberNo INT = 1;

SELECT TOP @MemberNo 'abc'
Msg 102 Level 15 State 1 Line 3
Incorrect syntax near '@MemberNo'.

DECLARE @MemberNo INT = 1;

SELECT TOP (@MemberNo) 'abc'

(No column name)

abc