Praise be to the SQL Development team!
In previous versions of SQL Server, you could not insert into a table variable by executing a stored procedure, this would fail
insert into @table (blah, meh)
execute Proc2
So, you would have to create a temp table to accomplish it.
SQL 2008!
You can now execute a stored procedure to populate a table variable!
Go forth SQL kodars, create data and execute procedures!
Monday, November 2, 2009
Subscribe to:
Posts (Atom)
Posts
