UFN_WPSOCIAL_PROFILES

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@WPSOCIALID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_WPSOCIAL_PROFILES(@WPSOCIALID uniqueidentifier) 
            returns table
            as return
                --select the biography information

                select
                    ID,
                    LOCATION,
                    OCCUPATION,
          COMPANY,
          EMAIL,
          SEQUENCE
                from
                    dbo.WPSOCIALPROFILE
                where
                    WPSOCIALID=@WPSOCIALID