Thursday, June 9, 2011

How to do SELECT TOP @Param in a Stored Procedure?

 How to do SELECT TOP @Param in a Stored Procedure? 

Here I have created an integer param which is used later in the SELECT statement.

CREATE PROCEDURE [dbo].[SP_get]
@my_param int   
AS
BEGIN
      SET NOCOUNT ON;

SELECT TOP (@top_param) col1, col2, col3
      FROM TableName 

0 comments:

Post a Comment

 

2011 ·Code-Studio by yrus.