How to check for null/empty/whitespace values with a single test?

-
The NULLIF function will convert any column value with only whitespace into a NULL value. Works for T-SQL and SQL Server 2008 & up.
SELECT [column_name]
FROM [table_name]
WHERE NULLIF([column_name], '') IS NULL

Comments

Post a Comment

Popular posts from this blog

Xampp MySQL not starting

-
Image
  If changing port number doesn't solve your problem, follow steps and this solves problem: (** By these steps don't need to reinstall Xampp or loss your database**) Stop all Xampp services and exit application. Move to c:\xampp\mysql Rename data folder to data_old create new data folder and copy whole content of backup folder to the data folder except "ibdata1"  5) Select all files in data_old folder and paste into data folder ( Note  Don't replace copied files and skip replace theme).
Read more

Multiple Login in Google Talk!

-
I wonder why this feature is not by default included in Google Talk. One can login simultaneously to more than one account. Unlike yahoo multiple login no need of registry editing here.Follow these simple steps.........* Create a shortcut of your Google talk.* Right click the shortcut ----> choose Properties.* In the "Target" you will find this "C:\Program Files\Google\Google Talk\googletalk.exe"* Now at the end of target add this "/nomutex" without the quotes. It should be like this "C:\Program Files\Google\Google Talk\googletalk.exe" /nomutex There is a space after googletalk.exe"Thats it .Click OK and you can open more than one Google talk.Amazing, isn't it?
Read more