Create trigger DelErrDate on Template
for Insert,Update,Delete
as
if exists(SELECT * FROM inserted)
Update Template set ReDate='' where ReDate='1900-01-01'
for Insert,Update,Delete
as
if exists(SELECT * FROM inserted)
Update Template set ReDate='' where ReDate='1900-01-01'
for Insert,Update,Delete
as
if exists(SELECT * FROM insert)
Begin
Update Template set ReDate='' where substring(cast(ReDate as varchar(20),1,10)='1900-01-01'
End
if exists(SELECT * FROM Update)
Begin
Update Template set ReDate='' wheresubstring(cast(ReDate as varchar(20),1,10)='1900-01-01'
End
for Insert,Update,Delete
as
if exists(SELECT * FROM inserted)
Update Template set ReDate=Null where DateDiff(dd,ReDate,'1900-01-01' )=0