snoopy9438
czołg
Dołączył: 14 Lut 2011
Posty: 2614
Przeczytał: 0 tematów
Ostrzeżeń: 0/10
Skąd: England
|
 Wysłany: Nie 1:14, 20 Mar 2011 Temat postu: sneaker heels nike|Should You Use An LLChzm |
|
|
reated with the following syntax:CREATE TRIGGER trigger_nameON { table view }[ WITH ENCRYPTION ]{{ { FOR AFTER INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }[ WITH APPEND ][ NOT FOR REPLICATION ]AS[ { IF UPDATE ( column )[ { AND OR } UPDATE ( column ) ][ ... n ] IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask ){ comparison_operator } column_bitmask [ ... n ]} ]sql_statement [ ... n ]}}There are two types of triggers: AFTER and INSTEAD OF. After triggers AFTER TRIGGERS fire after the data is changed, either by insert, delete, or update. If the data is inappropriate, as defined in the trigger [link widoczny dla zalogowanych], the modification can be rolled back to where it was before the data was modified. After triggers AFTER TRIGGERS cannot be placed on views, and cannot be used on more than one table. Also, the text [link widoczny dla zalogowanych], ntext, and image columns cannot be referenced in an after trigger. AFTER TRIGGERS.After triggers AFTER TRIGGERS can be nested to 32 levels deep, and can be called recursively, again to 32 levels.Instead of INSTEAD OF triggers make the validation before the modification. However [link widoczny dla zalogowanych], Instead of INSTEAD OF triggers CAN can be used on views. They do not allow recursion, and you can only have one Instead of INSTEAD OF trigger per table. And you cannot use an Instead of INSTEAD OF trigger wyilai：
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
Post został pochwalony 0 razy
|
|
