alter procedure DBA.WEBXMLDataEdit( @sp_Action smallint,@sp_pknRecID integer,@sp_WorkingCompany integer,@sp_XMLInfo timestamp,@sp_XMLType varchar(15),@sp_XMLData long varchar,@sp_DateReplication timestamp,@sp_DateImportAsakim timestamp,@sp_XMLID integer,@sp_nPopulationCardNumber integer,@sp_IDWEBSettings integer,@sp_TableName integer,@sp_ReturnedPknRecID integer output )
add @sp_TableName integer
add @sp_nPopulationCardNumber integer @sp_IDWEBSettings integer
add @sp_XMLID integer
add @sp_Action = 8
add DateImportAsakim
add DateReplication
created for project WEB
as
begin
declare @sp_Shrek integer
if(@sp_Action = 3)
begin
insert into WEBXMLData( WorkingCompany,
XMLInfo,XMLType,XMLData,DateReplication,
DateImportAsakim,XMLID,nPopulationCardNumber,
IDWEBSettings,TableName )
values( @sp_WorkingCompany,@sp_XMLInfo,@sp_XMLType,
@sp_XMLData,@sp_DateReplication,@sp_DateImportAsakim,
@sp_XMLID,@sp_nPopulationCardNumber,@sp_IDWEBSettings,@sp_TableName )
select @sp_ReturnedPknRecID = @@identity
end
else
if(@sp_Action = 2)
begin
update WEBXMLData
set WorkingCompany = @sp_WorkingCompany,XMLInfo = @sp_XMLInfo,XMLType = @sp_XMLType,
XMLData = @sp_XMLData,DateReplication = @sp_DateReplication,DateImportAsakim = @sp_DateImportAsakim,
XMLID = @sp_XMLID,nPopulationCardNumber = @sp_nPopulationCardNumber,IDWEBSettings = @sp_IDWEBSettings,
TableName = @sp_TableName where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 6)
begin
update WEBXMLData set XMLID = @sp_XMLID where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 7)
begin
update WEBXMLData set DateImportAsakim = @sp_DateImportAsakim where pknRecID = @sp_pknRecID
end
else
if(@sp_Action =
begin
update WEBXMLData set XMLData = @sp_XMLData where pknRecID = @sp_pknRecID
end
else
if(@sp_Action = 12)
begin
delete from WEBXMLData where pknRecID = @sp_pknRecID
end
end