I have plenty of tables that have triggers on them to update new inserts with supporting information.

Example - Insert into child table tableX with basic information, grabs information from parent table tableY and adds to the child record. These fields are then filled in with the defaults from the Parent for ease of use, but can be overridden at the child level rather than strictly inherited.

The issue is that there are also plenty of tables where the insert already has all the information (e.g. copy existing rows to a new year, copy from an existing system etc.)

Is there any syntax or feature that would behave similar to this:

Insert into tableX on existing skip with auto name NO TRIGGERS / PAUSE TRIGGERS

?

asked 07 Nov '16, 14:12

Siger%20Matt's gravatar image

Siger Matt
3.2k496697
accept rate: 13%


No, but you can program for this situation. See my other answer on this topic.

permanent link

answered 07 Nov '16, 14:21

Mark%20Culp's gravatar image

Mark Culp
23.2k9132273
accept rate: 40%

I knew I had seen it before, just couldn't find it in the search. Thanks Mark!

(07 Nov '16, 14:24) Siger Matt
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×60
×11

question asked: 07 Nov '16, 14:12

question was seen: 227 times

last updated: 07 Nov '16, 14:24