UFN_EXPORTDEFINITION_GETUNIQUENAME
Returns a unique name for an export definition by appending a counter when necessary.
Return
| Return Type |
|---|
| nvarchar(200) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(200) | IN | |
| @PREFIX | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.[UFN_EXPORTDEFINITION_GETUNIQUENAME]
(
@NAME nvarchar(200),
@PREFIX nvarchar(100) = 'Copy'
)
returns nvarchar(200)
as
begin
declare @UNIQUENAME nvarchar(200);
declare @COUNT int;
set @COUNT = 1;
set @UNIQUENAME = left(@PREFIX + ' of ' + @NAME, 200);
while exists(select top 1 1 from dbo.[EXPORTDEFINITION] where [NAME] = @UNIQUENAME)
begin
set @COUNT = @COUNT + 1;
set @UNIQUENAME = left(@PREFIX + ' (' + cast(@COUNT as nvarchar(10)) + ') of ' + @NAME, 200);
end
return @UNIQUENAME;
end