SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together

I receive a lot of emails every day. I try to answer each and every email and comments on Facebook and Twitter. I prefer communication on social media as this gives opportunities to others to read the questions and participate along with me. There is always some question which everyone likes to read and remember. Here is one of the questions which I received in email. How to replace a column name in multiple stored procedure efficiently and quickly? I believe the same question will be there any many developers who are beginning with SQL Server. I decided to blog about it so everyone can read it and participate.

Read More

SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video

Collation is a very important concept but often ignored. I have often seen developers either not understanding this or ignored it – this is plain wrong. In simple word we can say Collation is the language or interpreting done by SQL Server. Well, in today’s SQL in Sixty Seconds we…
Read More