I wrote a stored procedure, want to have the count (*) value to a variable, how to write, thank you

CodePudding user response:

 declare @ count as int 
The set @ count=(select count (*) from (select 1 te) as a) 
Select @ count