[dba-SQLServer]Selecting data into variables

Use output parameters

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
Emerson
Sent: Tuesday, October 07, 2003 10:56 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Selecting data into variables


I would like to run a select statement that returns 1 row, then put the 
column values into variables I have declared in my Sproc.  The closest I

have come across in BOL is the SELECT INTO statement but this is for 
"Embedded SQL for C and SQL Server".

I could use a cursor but it seems overkill for only one row.  Is there
an 
easy way to do this?

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com