In-Depth SQL Server 2008 Is Finally Here. Now What? Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? By Eric ...

I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then allow the SQL statement to continue.

BANGALORE, INDIA: In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. MERGE statement allows you to join a data source with a ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

When you use the BACKUP DATABASE statement in SQL Server 2005 (and beyond) you can use the READ_WRITE_FILEGROUPS option and the Read-only Filegroups will not be backed up.

If you omit the CONNECT statement, an implicit connection is performed (by using default values for all database connection arguments) when the first EXECUTE statement is passed to the DBMS. See your ...