create trigger on emp it allow sal more than 500

Question

Post reply

create trigger on emp it allow sal more than 500

viveksvkola

SSCrazy

Points: 2229
More actions
July 22, 2012 at 10:21 am

#261503

Hi
This is vivek.I want create trigger on emp it won't allow insert and update records in to emp sal less than 500.
please give me replay.
Thanks&Regards,
vivek,
viveksvkola@gmail.com.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Trigger is not required here. Alter your table to include CHECK Constraint with specified salary options.

Check the below links for implementation:

http://msdn.microsoft.com/en-us/library/ms188258%28v=sql.105%29.aspx

http://msdn.microsoft.com/en-us/library/ms179491%28v=sql.105%29.aspx

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Don't know the exact structure of the employee table you are using, but code would be something like this-

ALTER TABLE dbo.Employee

ADD CONSTRAINT CONS_Salary_nlt_500

CHECK (Salary > 500)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

A little difficult to understand what you are requesting, but if what you want to prevent is that a Salary amount can't be less than 500.00, all you need is a constraint on the column to states salry must be >= 500.00.