Setting an output parameter to the value of count() in sql stored procedure

Question

I have an output parameter @Counter and a temporary table #tmpUsers

Is it possible to assign the value of

SELECT COUNT(*) FROM #tmpUsers

To the @Counter output parameter?

I have tried

SET @Counter = SELECT COUNT(*) FROM #tmpUsers

But this doesn't work for me

Robert · Accepted Answer · 2013-08-06 10:40:33Z

14

Try this way:

SELECT @Counter = COUNT(*) 
FROM #tmpUsers

or

SET @Counter = (SELECT COUNT(*) FROM #tmpUsers)

answered Aug 6, 2013 at 10:40

Robert

25.8k8 gold badges70 silver badges86 bronze badges

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

1 Answer 1