Raise Error

[sujosh]

I have a very simple if condition. If the if condition fails I want to raise error. I keep getting "Incorrect syntax near the keyword Begin". Here is snippet of the code

If Not isnull (inserted.subs1," ")

BEGIN
RAISERROR ('Field SUBS1 Is Read Only. Updating this field will cause loss of integrity', 16, 1)
ROLLBACK TRANSACTION
END

Any help is appreciated
Thanks

 

[nigelrivett]

if not exists (select * from inserted where subs1 is null)

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[sujosh]

Thank you very much. Appreciate it!