Store Procedure Variables

[attock]

I know we can use 'set @myVar = "blah" ' to store a value to @myVar. Similarly we can also do:

 

set @myVar = 'Select * from xyz';

and then execure the string stored in @myVar as:

PREPARE sql FROM @myVar;

EXECUTE sql; // this would execute the query

 

 

However, my question is there a way to do sumthing like this:

set @myVar = EXECUTE('Select * from xyz'

I wana store the results of execution into a variable.

 

Thanks

 

 

 

 

[tekrscom]

Some really good information on that here... http://www.sqlteam.com/article/stored-procedures-returning-data