Cloud & SQLSailor

Cloud, Databases & Beyond!

Category: TSQL

  • SQLCMD and SET QUOTED_IDENTIFIER

    Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then this post will definitely help you. I was working on…

  • Cannot assign a default value to a local variable !

    You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try to declare a variable and assign it a value in…

  • Doing a count(*) can be really a bad idea

    Just learned that doing a count (*) is not that a great idea. People (So do I) often think that it will just pick the row count, but it will…

Explore