Tech Novice
asked on
Before Insert trigger in sql server
Hi,
I have to check the value of the record before inserting into the table,through application have received some records,now need to create trigger which says if its a particular case then it should not allow to insert,otherwise let it insert.
Is it possible in sql server i.e case of before insert or update in table using triggers?
I have to check the value of the record before inserting into the table,through application have received some records,now need to create trigger which says if its a particular case then it should not allow to insert,otherwise let it insert.
Is it possible in sql server i.e case of before insert or update in table using triggers?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Vitor Montalvão
Depending on your case, you can not even need a trigger if you create a check constraint instead.
ASKER
thanks