Tags » SQL Tips And Tricks

SQL SERVER - How to Flip Value of Bit Field in SQL Server?

How do you flip bit field in SQL Server?

Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. 127 more words

SQL Authority

SQL SERVER - Database Stuck in Restoring State

Here is a one of the very common question I keep on getting via email.

“I just restored all the backup files of my database, however, my database is still stuck in restoring state. 122 more words

SQL Authority

SQL SERVER - The Why of BIML - Notes from the Field #051

: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it.  1,161 more words

SQL Authority

SQL SERVER - Search Records with Single Quotes

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. 62 more words

SQL Authority