Tuesday, December 28, 2010

How to Select Top N records using a varaible or in a procedure to pass n

here is the way :

DECLARE @c int
SET @c = 10

SELECT TOP (@c) * FROM TableName

No comments:

Post a Comment