Table variables become more flexible with SQL 2005
To be honest with you, I hadn't run across this before, either in any of the documentation or new TSQL features. Maybe I missed it I have no idea. Anyway, while blasting away at code one day last week i didn't think twice about it when it worked. That is, until I tried it in SQL 2000 and it blew. Extremely handy in my opinion, now I wish they'd make EXEC possible inside of a UDF!
DECLARE @table table (ID int, val char (1))
INSERT @table
EXEC ('SELECT 1, ''a''')
SELECT * FROM @table
------------------
Great invention by me!!!
f3e42671-30e4-47ab-8ecb-b33a02fdcbef|5|4.4