The February 2007 update of SQL Server 2005 Books Online adds new material, fixes documentation problems and covers the product changes in Service Pack 2.
SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)
SQL Server 2005 Samples gave learners AdventureWorks and the smaller AdventureWorksLT. Why they mattered and where to find sample databases today.
SQL SERVER – Creating Comma Separate List From Table
This post now points to my updated script for creating a Comma Separate Values List from a table, rewritten in May 2007 to support SQL Server 2005.
SQL SERVER – FIX : Error 15023: User already exists in current database.
Error 15023: User already exists in current database. I fix it with sp_change_users_login, using Report, Auto_Fix or Update_One to link the user to a login.
SQL SERVER – Function to Convert List to Table
This old post now points to my updated UDF, the Function to Convert List to Table, which I rewrote in May 2007 to support SQL Server 2005.
SQL SERVER – Primary Key Constraints and Unique Key Constraints
Primary Key and Unique Key both enforce uniqueness, but they differ in the index they create and in NULL handling. Here are the differences and the scripts.
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case
My UDF udf_TitleCase converts any string to Title Case, also called Proper Case. The post has a sample call, its output and the full T-SQL code of the function.