Lots of people ask me how to stay in touch with SQLAuthority.com. Well, the answer is very simple, you can subscribe to the newsletter of SQLAuthority.com by going to URL here: https://go.sqlauthority.com.
SQL SERVER 2008 has introduced new concept of Compound Assignment Operators. Compound Assignment Operators are available in many other programming languages for quite some time. Compound Assignment Operators is operator where variables are operated upon and assigned on the same line.
I received following question in email : How to create a comma delimited list using SELECT clause from table column?
Very frequently Jr. Developers request script for creating default constraint over table column. I have written following small script for creating default constraint. I think this will be useful to many other developers who want this script to keep handy.