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