spCleanupDeleteLayoutPanes

Parameters

Parameter Parameter Type Mode Description
@LayoutID int IN
@PaneNames nvarchar(4000) IN

Definition

Copy



    create procedure [dbo].[spCleanupDeleteLayoutPanes]
  (
    @LayoutID int,
    @PaneNames nvarchar(4000) = ''
  )

  as 

    declare @SQL nvarchar(4000);

      set @SQL = 'delete from pagecontent where PaneName in (' +
        @PaneNames + ') and SitePagesID in (select id from dbo.fnGetDependencies(' + 
        cast(@LayoutID as nvarchar(10)) + ',1))'

        exec (@SQL);

    return 0;