Zubair.NET!

Here's a page that has few useful T-SQL queries that might come in handy during those days.

http://code.msdn.microsoft.com/SQLExamples

While some of them you may know already, here' re my favorites.

Create a Comma Delimited List

Control Return Results by Range

Delete All Data From All User Tables In A Database

Exploring Recursive Common Table Expressions (CTE)

Find and/or Delete Duplicate Rows in a Table

Labels: SQL Server, T-SQL

# posted by Zubair.NET! @ 4:06 PM