SQL Version of YesNoFormat

On February 15, 2008, in SQL, by Anuj Gakhar

I was reading some SQL tips and found this small but quite handy tip. If you have a boolean column in your database which holds values like 0 and 1 , you can modify your Select queries to represent that data as a Yes or No by doing this. [sql]SELECT SUBSTRING(‘YesNo’, 4 – 3 * […]

Tagged with:  

Database Compatibility Levels : How to change all at Once

On February 14, 2008, in SQL, by Anuj Gakhar

Before I begin, this post is specific to Microsoft Sql Server, for those who care. A little background :- If you migrate your databases from Sql Server 7.0 to Sql Server 2005, you are going to have to deal with this at some point, I think. So, once you you have your databases migrated into […]

Tagged with:  
© 2011 Anuj Gakhar