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;