UFN_INSTALLATIONINFO_GETINSTALLATIONNAME

create function dbo.UFN_INSTALLATIONINFO_GETINSTALLATIONNAME()
returns [nvarchar](100) with execute as caller
as
begin
    declare @name nvarchar(100)
    select top 1 @name=INSTALLATIONNAME from dbo.INSTALLATIONINFO where ID=1
    return @name
end