spAddUpdate_ECardTemplateFolder

Parameters

Parameter	Parameter Type	Mode	Description
@ECardTemplateID	int	IN
@Categories	ntext	IN
Definition

Copy


                create procedure dbo.spAddUpdate_ECardTemplateFolder
                (
                    @ECardTemplateID int,
                    @Categories ntext
                )
                AS
                    set nocount on;
                    DECLARE @Doc int;

                    BEGIN TRANSACTION spAddUpdate_ECardTemplateFolder;

                    EXEC sp_xml_preparedocument @Doc OUTPUT, @Categories;

                    DELETE FROM dbo.ECardTemplateFolder WHERE ECardTemplateID = @ECardTemplateID;

                    INSERT INTO dbo.ECardTemplateFolder(ECardTemplateID, SiteFoldersID)
                        SELECT @ECardTemplateID, SiteFoldersID 
                        FROM OPENXML(@Doc, 'ECardTemplate/Category', 1)
                        WITH (ECardTemplateID integer, SiteFoldersID integer)
                        WHERE SiteFoldersID > 0;

                    EXEC sp_xml_removedocument @Doc;

                    COMMIT TRANSACTION spAddUpdate_ECardTemplateFolder;