Can You Call A Sql Stored Procedure That Returns A Record Set And Have Those Values Loaded Into Variables?

Please consider the following SQL Server table and stored procedure. create table customers(cusnum int, cusname varchar(50)) insert into customers(cusnum, cusname) values(1, 'Ken

Solution 1:

No, you can't return values like that.

You need to use OutputParameters: MSDN.

EDIT:

This might be a better link:

SQL Team

Check out the section about midway down: Using OUTPUT variables