UFN_IMPORTFIXEDWIDTHFILETEMPLATE_GETIDFROMNAME

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@NAME nvarchar(255) IN

Definition

Copy


create function dbo.UFN_IMPORTFIXEDWIDTHFILETEMPLATE_GETIDFROMNAME(@NAME nvarchar(255))
returns uniqueidentifier
as
begin

    declare @ID uniqueidentifier;

    select 
    @ID = ID 
  from 
    dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
  where 
    NAME = @NAME;

    return @ID;

end;