We help IT Professionals succeed at work.

Insert Trigger

Medium Priority
206 Views
Last Modified: 2012-05-07
I cannot touch the inline SQL in an application - but need to check a value on insert and perform a case statement against a value - basically an ISNULL around one of the values - how do I check a value on INSERT and if = X then...
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Rob FarleyConsultant
CERTIFIED EXPERT

Commented:
Depending on more details about the problem, I'd try to work it into a computed column instead of a trigger. Triggers can be notorious for locking, etc.

Are you saying that you want to change a particular value to record when a value was changed in a certain way, or just that you want a particular column to reflect the result of an ISNULL? If it's the latter, then a computed column is definitely the way to go.

Rob
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.