MSDN Code Gallery - Solutions for Common T-SQL Problems
"Information presented in this WIKI represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums. (Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.)
...
How To Examples of selected T-SQL programming constructs
Create a Comma Delimited List from a Column in a Table
Create and Use A Numbers Table
Control Return Results by Range
Find and/or Delete Duplicate Rows in a Table
Find Rows of Data Between Two Dates
Increment an AlphaNumeric Value
Use ISNULL() and COALESCE()..."
Still in the early, initial phase, but could grow into a useful resource (actually it already is for me as I always forget COALESCE ;)
(via SQL Server Code,Tips and Tricks, Performance Tuning - Solutions for Common T-SQL Problems Wiki Launched)
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...