Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-09-02 : 17:07:35
|
| I have a trigger and inbetween there is a If statement which creates problem.without the 'if' it works.But I want a check needed in the triggerSELECT @emp_id=emp_number FROM inserted IF @emp_id <> NULL BEGIN ----- ----- End |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-02 : 17:09:17
|
| IF @emp_id IS NOT NULLTara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-02 : 17:11:43
|
| Thanks Tara,It works !!!! |
|
|
|
|
|
|
NULL value check