Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Triggers

Interview Question :: I have a trigger on table1 for update. Can this trigger update table1 too? Does it cause Deadlock

I am using SQL Server 2000.

Answers to "I have a trigger on table1 for update. Can this trigger update table1 too? Does it cause Deadlock"

RE: I have a trigger on table1 for update. Can this trigger update table1 too? Does it cause Deadlock?
Triggers are evil and should be avoided at all costs. Try to find another way to accomplish the task
Vote for this answer ::

RE: I have a trigger on table1 for update. Can this trigger update table1 too? Does it cause Deadlock?
You should be fine, this sort of behavior is normal. However, if the target field is always a reflection of some other field you may want to consider using a computed field instead.
Vote for this answer ::

RE: I have a trigger on table1 for update. Can this trigger update table1 too? Does it cause Deadlock?
Well trigger on a particular table are many times for the same table.. as for example: if we update positioln of employee then salary must be updated this trigger shall not coz a deadlock.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License