UFN_TRANSLATIONFUNCTION_IMPORTFILETEMPLATE_GETNAME
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_TRANSLATIONFUNCTION_IMPORTFILETEMPLATE_GETNAME(@ID uniqueidentifier) returns nvarchar(100)
as
begin
declare @NAME nvarchar(50);
set @NAME = isnull((select NAME + ' (delimited file)' from dbo.IMPORTFILETEMPLATE where ID = @ID), '');
if @NAME = '' begin
select @NAME = NAME + ' (fixed-width file)' from dbo.IMPORTFIXEDWIDTHFILETEMPLATE where ID = @ID
end
return @NAME;
end