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 ...

support multiple sql statement seperate by semicolon support select, delete, update and insert type support drop, truncate and rename command output the table and column list that the sql visited with ...