CREATE TABLE [dbo].[PROPVALUE](
	[BOLD_ID] [int] NULL,
	[BOLD_TYPE] [smallint] NULL,
	[BU_MAX] [float] NULL,
	[BU_MIN] [float] NULL,
	[BU_ORIGIN] [float] NULL,
	[FORMATTYPE] [int] NULL,
	[TEXTVALUE] [varchar](255) NULL,
	[ENUMITEM] [int] NULL,
	[CONTEXT] [int] NULL,
	[PROPHAVINGOBJECT] [int] NULL,
	[PROPDEF] [int] NULL,
	[OPTIONS] [int] NULL
) ON [PRIMARY]

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create TRIGGER [dbo].[CHANGE_PROPVALUE] ON [dbo].[PROPVALUE]
AFTER INSERT, DELETE, UPDATE
as 
BEGIN
 
  SET NOCOUNT ON;

	IF EXISTS(SELECT * FROM DELETED) AND EXISTS(SELECT * FROM INSERTED)
	update MISORA..DBMISIMP.PROPVALUE  
	set [BOLD_TYPE] = INSERTED.BOLD_TYPE,
	[BU_MAX] = INSERTED.BU_MAX,
	[BU_MIN] = INSERTED.BU_MIN,
	[BU_ORIGIN] = INSERTED.BU_ORIGIN,
	[FORMATTYPE] = INSERTED.FORMATTYPE,
	[TEXTVALUE] = INSERTED.TEXTVALUE,
	[ENUMITEM] = INSERTED.ENUMITEM,
	[CONTEXT] = INSERTED.CONTEXT,
	[PROPHAVINGOBJECT] = INSERTED.PROPHAVINGOBJECT,
	[PROPDEF] = INSERTED.PROPDEF,
	[OPTIONS] = INSERTED.OPTIONS
	from INSERTED where PROPVALUE.BOLD_ID in (select BOLD_ID from INSERTED)

	IF EXISTS(SELECT * FROM DELETED) AND NOT EXISTS(SELECT * FROM INSERTED)
	delete from MISORA..DBMISIMP.PROPVALUE where bold_id in (select bold_id from DELETED)
  

  IF NOT EXISTS(SELECT * FROM DELETED) AND  EXISTS(SELECT * FROM INSERTED)
	insert MISORA..DBMISIMP.PROPVALUE([BOLD_ID],[BOLD_TYPE],[BU_MAX],[BU_MIN],[BU_ORIGIN],[FORMATTYPE],[TEXTVALUE],[ENUMITEM],[CONTEXT],[PROPHAVINGOBJECT],[PROPDEF],[OPTIONS])
	select [BOLD_ID],[BOLD_TYPE],[BU_MAX],[BU_MIN],[BU_ORIGIN],[FORMATTYPE],[TEXTVALUE],[ENUMITEM],[CONTEXT],[PROPHAVINGOBJECT],[PROPDEF],[OPTIONS] from INSERTED
 
END

GO

delete from MISORA..DBMISIMP.PROPVALUE where bold_id=12345

delete from MISORA..DBMISIMP.PROPVALUE where bold_id=12345

begin transaction
delete from MISORA..DBMISIMP.PROPVALUE where bold_id=12345
commit transaction