USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONCMSCOPY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@VANITYNAME	nvarchar(512)	INOUT
@URL	nvarchar(max)	INOUT
@CMSCHILDREN	nvarchar(max)	INOUT
@STARTDATE	datetime	INOUT
@ENDDATE	datetime	INOUT
@ISACTIVE	bit	INOUT
@CMS	bit	INOUT
@ISLIVE	bit	INOUT
@SITEPAGESID	int	INOUT

Definition

Copy


            create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONCMSCOPY
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @VANITYNAME nvarchar(512) = null output,
                    @URL nvarchar(max) = null output,
                    @CMSCHILDREN nvarchar(max) = null output,
            @STARTDATE datetime = null output,
                    @ENDDATE datetime = null output,
            @ISACTIVE bit = null output, 
            @CMS bit = null output,
            @ISLIVE bit = null output,
            @SITEPAGESID int = null output
                )
                as
                    set nocount on;

            exec dbo.USP_DESIGNATIONCMS_VIEWDATA @ID, @DATALOADED output, @VANITYNAME output, @URL output, @CMSCHILDREN output, @STARTDATE output, @ENDDATE output, @ISACTIVE output, @CMS output, @ISLIVE output, @SITEPAGESID output;

                    return 0;