SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE [dbo].[SubTable]( [Id] [int] IDENTITY(1, 1) NOT NULL, [Table] [nvarchar](64) NULL, [LatUpdateTime] [datetime2](7) NULL, [ClientTableId] [int] NULL, CONSTRAINT [PK_SubTable] PRIMARY KEY CLUSTERED ([Id] ASC) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY]; CREATE TABLE [dbo].[MainTable]( [ID] [int] IDENTITY(1, 1) NOT NULL, [Name] [nvarchar](max) NOT NULL CONSTRAINT [PK_MainTable] PRIMARY KEY CLUSTERED ([ID] ASC) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; insert into [dbo].[MainTable] VALUES ('check1'), ('check2'); insert into [dbo].[SubTable] VALUES ( '[dbo].[MainTable]', SYSDATETIME(), 1 ), ( '[dbo].[MainTable]', SYSDATETIME(), 2 ); select * from [dbo].[MainTable]; select * from [dbo].[SubTable]; Create trigger Update_applicationUpdate_MainTable on MainTable after update as Update [SubTable] with(ROWLOCK) set [LatUpdateTime] = SYSDATETIME() where [dbo].[SubTable].[ClientTableId] in (select Id from inserted) and [Table] = '[dbo].[MainTable]'; update [dbo].[MainTable] set [Name] = 'Тестовый37' where id = 1; select * from [dbo].[SubTable];