UFN_NETCOMMUNITYDEFAULTCODEMAP_GETDONOTMAILCONSENTSOLICITCODE

create function dbo.UFN_NETCOMMUNITYDEFAULTCODEMAP_GETDONOTMAILCONSENTSOLICITCODE()
returns uniqueidentifier
with execute as caller
as begin
    -- do work here and return a value

    declare @NOEMAILCONSENTSOLICITCODEID uniqueidentifier
    select top 1 @NOEMAILCONSENTSOLICITCODEID=DONOTEMAILCONSENTSOLICITCODEID
    from NETCOMMUNITYDEFAULTCODEMAP

    return @NOEMAILCONSENTSOLICITCODEID
end