CREATE TRIGGER tr_equip_reservation_update on
EQUIP_RESERVATION
FOR update AS
BEGIN
declare @data varchar(255), @data2 varchar(255) , @data3
varchar(255) , @data4 varchar(255) , @data5 varchar(255)
SELECT
@data = 'UPDATE EQUIP_RESERVATION SET '+
'rev_id = ' +
convert(varchar,isnull(inserted.rev_id,0)) + ', '+
'organ_code = ''7777'', '+
'equip_code = ' +
convert(varchar,isnull(inserted.equip_code,0)) + ', '+
'name = ''' + inserted.name + ''', '+
'allow = ''' +inserted.allow +'''.'+
'reason = '''+inserted.reason+''','+
'etc = ''' + inserted.etc + ''', '+
'pro_use = ''' + inserted.pro_use + ''', '+
'use_method = ' + inserted.use_method + ', '+
'com_tel = ''' + inserted.com_tel + ''', '+
'per_tel = ''' + inserted.per_tel + ''', '+
'admin_id = ''' + inserted.admin_id + ''', '+
'kor_equip = ''' + inserted.kor_equip + ''','+
'company = ''' + inserted.company + ''',
',
@data2 = 'start_day = to_date(''' + convert(char(10),
inserted.start_day, 111) + ' '+convert(char(8), inserted.start_day,
108)+''',''yyyy/mm/dd''), ',
@data3 = 'end_day = to_date(''' + convert(char(10),
inserted.end_day, 111) + ' '+convert(char(8), inserted.end_day,
108)+''',''yyyy/mm/dd''), ',
@data4 = 'reg_day = to_date(''' + convert(char(10),
getdate(), 111) + ' '+convert(char(8), getdate(),
108)+''',''yyyy/mm/dd HH24:MI:SS'') ',
@data5 ='WHERE rev_id = ' +
convert(varchar,isnull(inserted.rev_id,0)) + ' AND organ_code =
''7777'' AND equip_code = ' +
convert(varchar,isnull(inserted.equip_code,0))
FROM inserted
INSERT INTO TB_INFO
VALUES ( '7777', 'N', 'EQUIP_RESERVATION', 'U',
convert(char(10), getdate(), 111), convert(char(8), getdate(),
108), @data+@data2+@data3+@data4+@data5 )
END
|