USE [zol] GO /****** Object: Trigger [dbo].[SYM_ON_U_FOR_RGHTSHLDR_NVC_ZL] Script Date: 2019-01-14 23:57:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create trigger [dbo].[SYM_ON_U_FOR_RGHTSHLDR_NVC_ZL] on [zol].[dbo].[rightsholder_invoice] with execute as caller after update as begin declare @NCT int set @NCT = @@OPTIONS & 512 set nocount on declare @TransactionId varchar(1000) if (@@TRANCOUNT > 0) begin select @TransactionId = convert(VARCHAR(1000),transaction_id) from sys.dm_exec_requests where session_id=@@SPID and open_transaction_count > 0 end if ("zol".dbo.sym_triggers_disabled() = 0) begin insert into "zol"."dbo".sym_data (table_name, event_type, trigger_hist_id, row_data, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time) select 'rightsholder_invoice','U', 65, case when inserted."rightsholder_invoice_id" is null then '' else ('"' + convert(varchar(40), inserted."rightsholder_invoice_id",2) + '"') end+','+ case when inserted."rightsholder_invoice_datetime" is null then '' else ('"' + convert(varchar,inserted."rightsholder_invoice_datetime",121) + '"') end+','+ case when inserted."rightsholder_id" is null then '' else ('"' + convert(varchar(40), inserted."rightsholder_id",2) + '"') end+','+ case when inserted."number" is null then '' else '"' + replace(replace(convert(varchar(128),inserted."number") ,'\','\\'),'"','\"') + '"' end+','+ case when inserted."income_date" is null then '' else '"' + replace(replace(convert(varchar(10),inserted."income_date") ,'\','\\'),'"','\"') + '"' end+','+ case when inserted."invoice_date" is null then '' else '"' + replace(replace(convert(varchar(10),inserted."invoice_date") ,'\','\\'),'"','\"') + '"' end+','+ case when inserted."sale_date" is null then '' else '"' + replace(replace(convert(varchar(10),inserted."sale_date") ,'\','\\'),'"','\"') + '"' end+','+ case when inserted."rightsholder_invoice_type_id" is null then '' else ('"' + convert(varchar(40), inserted."rightsholder_invoice_type_id",2) + '"') end+','+ case when inserted."status_description" is null then '' else '"' + replace(replace(convert(varchar(128),inserted."status_description") ,'\','\\'),'"','\"') + '"' end+','+ case when orig."comment" is null then '' else '"' + replace(replace(cast(orig."comment" as varchar(max)),'\','\\'),'"','\"') + '"' end+','+ case when inserted."correcting_rightsholder_invoice_id" is null then '' else ('"' + convert(varchar(40), inserted."correcting_rightsholder_invoice_id",2) + '"') end+','+ case when inserted."GUID" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."GUID") ,'\','\\'),'"','\"') + '"' end+','+ case when inserted."LAST_UPDATE_DATE_TIME" is null then '' else '"' + replace(replace(convert(varchar(27),inserted."LAST_UPDATE_DATE_TIME") ,'\','\\'),'"','\"') + '"' end, case when deleted."rightsholder_invoice_id" is null then '' else ('"' + convert(varchar(40), deleted."rightsholder_invoice_id",2) + '"') end, case when deleted."rightsholder_invoice_id" is null then '' else ('"' + convert(varchar(40), deleted."rightsholder_invoice_id",2) + '"') end+','+ case when deleted."rightsholder_invoice_datetime" is null then '' else ('"' + convert(varchar,deleted."rightsholder_invoice_datetime",121) + '"') end+','+ case when deleted."rightsholder_id" is null then '' else ('"' + convert(varchar(40), deleted."rightsholder_id",2) + '"') end+','+ case when deleted."number" is null then '' else '"' + replace(replace(convert(varchar(128),deleted."number") ,'\','\\'),'"','\"') + '"' end+','+ case when deleted."income_date" is null then '' else '"' + replace(replace(convert(varchar(10),deleted."income_date") ,'\','\\'),'"','\"') + '"' end+','+ case when deleted."invoice_date" is null then '' else '"' + replace(replace(convert(varchar(10),deleted."invoice_date") ,'\','\\'),'"','\"') + '"' end+','+ case when deleted."sale_date" is null then '' else '"' + replace(replace(convert(varchar(10),deleted."sale_date") ,'\','\\'),'"','\"') + '"' end+','+ case when deleted."rightsholder_invoice_type_id" is null then '' else ('"' + convert(varchar(40), deleted."rightsholder_invoice_type_id",2) + '"') end+','+ case when deleted."status_description" is null then '' else '"' + replace(replace(convert(varchar(128),deleted."status_description") ,'\','\\'),'"','\"') + '"' end+','+ ''+','+ case when deleted."correcting_rightsholder_invoice_id" is null then '' else ('"' + convert(varchar(40), deleted."correcting_rightsholder_invoice_id",2) + '"') end+','+ case when deleted."GUID" is null then '' else '"' + replace(replace(convert(varchar(36),deleted."GUID") ,'\','\\'),'"','\"') + '"' end+','+ case when deleted."LAST_UPDATE_DATE_TIME" is null then '' else '"' + replace(replace(convert(varchar(27),deleted."LAST_UPDATE_DATE_TIME") ,'\','\\'),'"','\"') + '"' end, 'zol_to_zapaonline', @TransactionId, "zol".dbo.sym_node_disabled(), null, current_timestamp from inserted inner join "zol"."dbo"."rightsholder_invoice" orig on orig."rightsholder_invoice_id"=inserted."rightsholder_invoice_id" inner join deleted on deleted."rightsholder_invoice_id"=inserted."rightsholder_invoice_id" where 1=1 and (1=1) end if (@NCT = 0) set nocount off end ---- go GO ALTER TABLE [dbo].[rightsholder_invoice] ENABLE TRIGGER [SYM_ON_U_FOR_RGHTSHLDR_NVC_ZL] GO