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

Sorting character strings using SQL Server

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...
Ars Technica

SQL Server 05 - Symantec Backup Exec vs... RedGate vs. TSQL... thoughts?

We are getting a new SQL server to run a vendor application.<BR><BR>The other sys admins want to get Symantec Backup Exec version 10D's SQL Agent for the server.<BR><BR>I personally think it would be ...
Redmond Magazine

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...