SQL Server/T-SQL/Trigger/inserted table

Материал из SQL эксперт
Перейти к: навигация, поиск

Query inserted and deleted table

   <source lang="sql">

3> create table Billings ( 4> BankerID INTEGER, 5> BillingNumber INTEGER, 6> BillingDate datetime, 7> BillingTotal INTEGER, 8> TermsID INTEGER, 9> BillingDueDate datetime , 10> PaymentTotal INTEGER, 11> CreditTotal INTEGER 12> 13> ); 14> GO 1> 2> INSERT INTO Billings VALUES (1, 1, "2005-01-22", 165, 1,"2005-04-22",123,321); 3> GO (1 rows affected) 1> INSERT INTO Billings VALUES (2, 2, "2001-02-21", 165, 1,"2002-02-22",123,321.); 2> GO (1 rows affected) 1> 2> 3> 4> CREATE TRIGGER trStudentsEcho 5> ON Billings 6> FOR UPDATE, INSERT, DELETE 7> AS 8> SELECT * FROM inserted 9> SELECT * FROM deleted 10> GO 1> 2> drop trigger trStudentsEcho; 3> GO 1> 2> drop table Billings; 3> GO

</source>