USP_DATAFORMTEMPLATE_EDITLOAD_WPSOCIAL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@FULLNAME	nvarchar(600)	INOUT
@GENDER	int	INOUT
@LOCATION	nvarchar(2048)	INOUT
@OCCUPATION	nvarchar(1024)	INOUT
@COMPANY	nvarchar(2048)	INOUT
@WPSOCIALPROFILES	xml	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPSOCIAL (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @FULLNAME nvarchar(600) = null output,
            @GENDER int = null output,
            @LOCATION nvarchar(2048) = null output,
            @OCCUPATION nvarchar(1024) = null output,
            @COMPANY nvarchar(2048) = null output,
            @WPSOCIALPROFILES xml = null output)
            as begin

                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

            select 
                            @DATALOADED = 1,
                            @TSLONG = TSLONG,
              @FULLNAME = FULLNAME,
              @GENDER = GENDERCODE,
              @LOCATION = LOCATION,
              @OCCUPATION = OCCUPATION,
              @COMPANY = COMPANY,
              @WPSOCIALPROFILES = dbo.UFN_WPSOCIAL_PROFILES_TOITEMLISTXML(@ID)
            from dbo.WPSOCIAL
            where ID = @ID

            return 0;

            end