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