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 ...
I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on ...