spAddUpdate_LanguageGuid_BULK
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@xml | xml | IN |
Definition
Copy
CREATE PROC [dbo].[spAddUpdate_LanguageGuid_BULK](@xml as xml) AS
begin
declare @Temp table(FID int, AID int, unique(FID, AID))
insert into @Temp(FID, AID)
select X.Fields.value('FieldID[1]', 'int') [FieldID],
X.Fields.value('AttribID[1]', 'int') [AttributeID]
FROM @xml.nodes('/ArrayOfLanguageGuid/LanguageGuid') X(Fields)
delete from @Temp where exists(select FieldID from LanguageGuid where FieldID = FID and AttributeID = AID)
insert into LanguageGuid ([FieldID], [AttributeID])
select FID, AID from @Temp
end