Modify Database Insert Default date

Nullif () function Use explanation

2014-06-23 23:16 by Zwwhnly, 2992 Reading, collection, compilation

The Nullif () function accepts two parameters. Returns a null value if they are equal, otherwise returns the first argument.

Equivalent to the following expression:

Case if Expression1=expression2 then Nullelse expression1end

The Nullif () function is typically used to prevent the addition of 0 errors.

If variable b is 0, the following expression generates an error, but you can use the Nullif () function so that if the value of variable B is 0, it returns null instead of an error

Select A/bselect A/nullif (b,0)

sql2005 if the type of the field definition is datetime, insert as"'(empty), then the default value is 1900- on- on xx:xx:00.000the solution query is filtered by the cast (Nullif("',"') as datetime) [SQL] ViewPlain CopySelect cast("'  as datetime)      , cast(Nullif("',"') as datetime)      , IsNull(cast(Nullif("',"') as datetime),getdate())  /*---------------------------------------------------------------------1900-01-01 00:00:00.000 NULL 2009-02-25 17:18:15.140 (1 rows affected)*/  

Modify Database Insert Default date