|
Wersja 614, 476 bytes
(wprowadzona przez marek, 17 years temu)
|
|
re #160 - poprawiono dodawanie klienta
|
| Line | |
|---|
| 1 |
|
|---|
| 2 | SET ANSI_NULLS ON
|
|---|
| 3 | GO
|
|---|
| 4 | SET QUOTED_IDENTIFIER ON
|
|---|
| 5 | GO
|
|---|
| 6 |
|
|---|
| 7 | ALTER TRIGGER [KLIENCI_DELETE]
|
|---|
| 8 | ON [dbo].[KLIENCI]
|
|---|
| 9 | FOR DELETE
|
|---|
| 10 | AS
|
|---|
| 11 |
|
|---|
| 12 | DECLARE @id INT
|
|---|
| 13 | DECLARE @Klient nvarchar(50)
|
|---|
| 14 | SELECT @id=CustomerId, @Klient=FirstName FROM deleted
|
|---|
| 15 |
|
|---|
| 16 | -- zapis do logu
|
|---|
| 17 | INSERT INTO dbo.[LOG](OPERACJA, TABELA, OPIS)
|
|---|
| 18 | VALUES('DELETE', 'KLIENCI', 'ID: ' + CAST(@id AS varchar) + ' | Name: ' + @Klient + ' | User: ' + USER_NAME())
|
|---|
| 19 |
|
|---|
| 20 |
|
|---|
| 21 | GO
|
|---|
| 22 |
|
|---|
| 23 | SET ANSI_NULLS OFF
|
|---|
| 24 | GO
|
|---|
| 25 | SET QUOTED_IDENTIFIER OFF
|
|---|
| 26 | GO
|
|---|
| 27 |
|
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.
