« Incremental changes and inconsistent design | Main | Django Subversion Installation on Mac OS X »
Saturday
Aug092008

SQL Trigger: Enabling/disabling 

You may come across a time when you want to INSERT additional records into a table. But the INSERT statement may have been using a TRIGGER, which may affect other tables. In this scenario, you can use enable/disable properties of the trigger rather than deleting and re-creating it again. Just use the following:

ALTER TABLE yourtablename DISABLE TRIGGER ALL

--Here write your additional script

ALTER TABLE yourtablename ENABLE TRIGGER ALL

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (1)

References allow you to track sources for this article, as well as articles that were written in response to this article.
  • Response
    Response: have a peek here
    Awesome Website, Carry on the excellent work. Thank you so much.

Reader Comments (7)

they are not seeing as good seeing as some of those of the very real pieces. Thus, do not expect to find real jewelry on the very replica wrist watch. IWC replica watches,Most of their diamonds or gemstones are synthetic for decoration. Anyhow

July 29, 2010 | Unregistered Commenterivan.watcheslux

The style of Links of London 2010 new arrivals
is related to one's face shape. People with triangular face are not suitable to wear long links of london
with pendants while earrings in round shape can offer a sense of coordination. If you have an oval face, you can wear links london
in any style. Round-faced people should avoid wearing small or oblate cheap links of london

August 12, 2010 | Unregistered Commenterswf

buy iphone 3g|
Your article is very good! I like it very much,but If you can add more video and pictures can be much better, I have never read such a lovely article and I am coming back tomorrow to continue reading.

November 29, 2010 | Unregistered CommenterLay D. Craig

Great, I like it very much, but if more pictures will be better, looking forward to your next post, I hope can read again other article like this post, you can also read us about wholesale womens clothing and cheap urban clothing for men information, in the hope that it useful to you .

June 17, 2011 | Unregistered CommenterSaya Craig

your flats-sale details is really reasonable skytop and friendfinder unique I title_supra-i-am very development concerned way about tory-burch sports ry_id=6336 and personality I Social believe individual only member sports midnigh can supra make ineartists you energetic. society I -philippine want to buy love some -sale-of- sports clubdestrois thing blog ,will dreamdatetonight you society give burch some suggestions suitable for sadOften me supra from burch below mybigrecord websites member-vortexavirtualparty your details congrats2u is little really reasonable happiness and gkode unique skytop I supra very ople-s- concerned close about show sports celestronlife and reva I member believe ost&owne only supra sports can make clubbingz you burch energetic. blogentry I assimilation want mind to elusiveEmotion buy title some burch sports -happy thing ,will picture you show-matter give some suggestions for itemid me from flats below websites ? apcmty boots

October 15, 2011 | Unregistered Commenterqq398053

<p>Helplessly watched the light on his brow, Mu Chen is unable to escape, when white light from him and a scale far when, he saw, flying is augg boots sale previous hit him in the shoulder in the heart of the stone as like as two peas. Iugg boots clearancen the face of the flying stones, he helpless eyes closed.</p>

December 6, 2011 | Unregistered Commenterwendy

This is what I have been searching in many websites and I finally found it here. Amazing article. I am so impressed. Could never think of such a thing is possible with it...I think you have a great knowledge especially while dealings with such subjects.Houston Home Security

December 21, 2011 | Unregistered CommenterHouston Home Security

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>