트리거
-
MS-SQL 트리거 인서트(insert)시 업데이트(update)프로그램/Mssql 2024. 1. 23. 11:56
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[UT_LEEKMAN_GET] ON [dbo].LEEKMAN FOR INSERT AS DECLARE @AAA VARCHAR(20) DECLARE @BBB CHAR(1) DECLARE @CCC VARCHAR(100) DECLARE @ZZZ CHAR(1) DECLARE @QRY VARCHAR(500) DECLARE INSERTED_CURSOR CURSOR FOR SELECT AAA, BBB, CCC, ZZZ FROM INSERTED OPEN INSERTED_CURSOR FETCH NEXT FROM INSERTED_CURSOR INTO @AAA, @BBB, @CCC, @ZZZ WHILE @@F..