I turned up something in a search I wanted to confirm - that I can't do the following:<BR><BR>INSERT INTO table_a<BR>(col_b, <BR> col_c)<BR>VALUES<BR>('blah',<BR>SELECT id FROM table_b WHERE name IS ...
this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...