declare @module_cd as varchar(3), @ver_info as varchar(8) set @module_cd = 'XHT' set @ver_info = '20080416' delete from smadiary where module_cd = @module_cd and ver_info = @ver_info insert into smadiary (module_cd, upgrade_dt, ver_info, solution_cd) values (@module_cd, getdate(), @ver_info, 'X') GO