SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
NULLIF
.
Show all posts
Showing posts with label
NULLIF
.
Show all posts
Tuesday, November 06, 2007
Return Null If A Value Is A Certain Value
›
You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLAR...
Monday, August 20, 2007
Do you know how NULLIF and non-deterministic functions work?
›
Run this first CREATE TABLE #j (n varchar (15)) DECLARE @a int SET @a = 1 WHILE @a BEGIN INSERT #j SELECT NULLIF ( REPLICATE ( '1...
›
Home
View web version