1

Topic: Trigger Update

Good afternoon.
On the table trigger AFTER UPDATE

UPDATE t1
set t1.FLagN=1
from tabl1 t1, inserted i
where t1.id=i.id

In the table about 20 fields, it is necessary to eliminate trigger actuating on update 1 fields from these 20...
if update () and to enumerate all fields somehow not so, especially field can be added in due course

2

Re: Trigger Update

r77;
More in detail!
http://www.sql.ru/forum/127456/rekomend … y-v-forume item 6

3

Re: Trigger Update

r77;
To look aside https://docs.microsoft.com/ru-ru/sql/t- … ansact-sql

4

Re: Trigger Update

felix_ff;
I thank

5

Re: Trigger Update

iap;
To you my question is not clear?

6

Re: Trigger Update

iap wrote:

r77;
More in detail!
http://www.sql.ru/forum/127456/rekomend … y-v-forume item 6

2 tables, at any change of the data of one table in the second should be delivered =1
But at present it is necessary that changes in one field to the table we name it DateOut did not affect change of a flag in the second table

7

Re: Trigger Update

r77 wrote:

iap;
To you my question is not clear?

do not want - your business.

8

Re: Trigger Update

iap wrote:

it is passed...
Do not want - your business.

I wrote above...

9

Re: Trigger Update

Thanks, just that that are necessary, my case, can to someone it is useful
https://habrahabr.ru/sandbox/69984/