stored proc simple question about select 1

[MarkGreen]

Hi,
I'm new to T-SQL and so this is a simple question, but one that I cannot find the answer to anywhere.

I need to return an integer value from a select statement into a local variable.

I don't understand what happens to the recordset after it has been returned by the select statement. How can you access it?

Thanks,
Mark

 

[JamesLean]

As long as the SELECT statement returns a single row, you can use this syntax:

DECLARE @var int

SELECT @var = ColumnName
FROM TableName
WHERE <condition list>
...

--James

 

[MarkGreen]

Thanks, that helped me do what I wanted to do.
Just out of interest, what happens if more than more record is returned?

 

[JamesLean]

From BOL:

If the SELECT statement returns more than one value, the variable is assigned the last value returned.

Look up assigning variables in BOL for further info. --James

 

[SQLSister]

If it returns more than one value, you could insert the values of the selct statement into a temp table or table vaiable and then use that to do any furthe r processing you want to do.