Using Top distinction with output parameter in SQL Server

Question

Is it possible to use a top distinction with an output parameter in SQL?
I am trying to use the below code and getting a syntax error:

@returnParam int output = 0

Select @returnParam = top 1 Id 
From table
Where xyz

Whereas taking out the top 1 the query has no errors. I could probably nest the query to get the top 1 from an inner query, but I don't think that is ideal.

Thanks!

marc_s · Accepted Answer · 2015-08-11 20:45:15Z

3

Try it like this:

@returnParam int output = 0

Select top (1) 
    @returnParam =  Id 
From table
Where xyz

Put the TOP (1) first - before the assignment to the output parameter.

You can find this (and much more) in the official MSDN documentation (the "SQL Server Books Online" - freely available to anyone!)

answered Aug 11, 2015 at 20:45

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DDushaj Over a year ago

thank you this solved it! also, honorable mention to Rahul who cam in only 24 seconds after your answer

Rahul · Accepted Answer · 2015-08-11 20:46:12Z

0

There is a bit syntax issue with your query. It should be

Select top 1 @returnParam =  Id 
From table
Where xyz;

answered Aug 11, 2015 at 20:46

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Collectives™ on Stack Overflow

Using Top distinction with output parameter in SQL Server

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related