Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

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

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...