Save ROWCOUNT value in a variable

[nt_virus]

Hello. I want to save the RowCount returned value in a variable and want to print (+1 with 'A' prefix). I created a variable as int.

declare @TotalIntRow as int

Now I'm unable to assign the returned value of rowcount in a variable. i use these ..

@TotalIntRow = select Count(*) from Rcount

Error :- Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@TotalIntRow".

set @TotalIntRow = select Count(*) from Rcount

Error : - Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'select'.

[I also tried to add a demo value , Set @TotalIntRow = 1; , but showing message number 137 as above mentioned] How could I save the value in it.

[Lost User]

Try this one;

DECLARE @TotalIntRow AS INT
SET @TotalIntRow = (SELECT COUNT(*)
FROM Rcount)
PRINT @TotalIntRow

Don't forget that the DECLARE statement should be used to declare the variable, before using it. Hope this helps :)

I are troll :)

[nt_virus]

Awesome mate. But I cant understand one thing, if I do these steps individually I got scalar error something. why so ? just curious about it. Ain't the values are stored permanently in it? BTW.. If even I run the above scripts do the variable takes additional space or they get removed after application shutdown?

Begin
DECLARE @TotalIntRow AS INT
SET @TotalIntRow = (SELECT COUNT(*)
FROM Rcount)
print @TotalIntRow + 1
Insert into Rcount Values(@TotalIntRow)
End

I m getting my partial desired result. I want to add prefix 'A' with the result set .. When I did .. I got , can't convert (variable declared for storing A) to int data type..

[nt_virus]

Oh my god, I can't believe I did it..

Begin
DECLARE @TotalIntRow AS INT
SET @TotalIntRow = (SELECT COUNT(*)
FROM Rcount)
print @TotalIntRow + 1
Insert into Rcount Values('A'+ Convert(varchar, @TotalIntRow))
End

[Lost User]

Well done dude :cool:

nt_virus wrote:

But I cant understand one thing, if I do these steps individually I got scalar error something. why so ? just curious about it. Ain't the values are stored permanently in it?

Not permanent, they are 'lost' once the command is finished executing. (In this case, once it passes the END statement) That's also the reason why they can't be executed separate, they are interpreted as separate commands if you execute them line by line separately.

nt_virus wrote:

BTW.. If even I run the above scripts do the variable takes additional space or they get removed after application shutdown?

They are gone as soon as the script (the complete collection of lines) are finished, unless you store them in a table somewhere. Most applications execute their script and close the connection to the database when done. Good work :)

I are troll :)