fnGetSiteCultures

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@ClientSitesId int IN

Definition

Copy



    create FUNCTION [dbo].[fnGetSiteCultures]
    (
        @ClientSitesId int
    )
RETURNS @SiteCultures TABLE (
    [Name] nvarchar(10), 
    [Description] nvarchar(100)
)
AS
begin
    insert into @SiteCultures

    SELECT 
        [Name],
        [Description]
    FROM    
        dbo.SiteCultures
    where ClientSitesId=@ClientSitesId
    order by [Description]

return
end