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