InfoQ

Google Proposes Adding Pipe Syntax to SQL

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
Visual Studio Magazine

SQL Server Data Services: What Is It?

My colleague, senior editor, Kathleen Richards was at MIX08 in Las Vegas two weeks ago. Suffice to say she received a brain dump on Silverlight and a number of other big announcements there. When she ...
Ars Technica

SQL Syntax for Updating datetime Field

I just added a field, 'ExportDate' to a table (AYP) in my MS SQL 2000 database. Since I added the field to an existing table, the values for 'ExportDate' in all records is <null>.<P>What I need to do ...
Ars Technica

SQL Server 2005 TSQL syntax for getting dta out of an update or insert

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