spUniqueName
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CurrentName | nvarchar(60) | IN | |
| @NewName | nvarchar(100) | INOUT |
Definition
Copy
CREATE PROCEDURE [dbo].[spUniqueName] @CurrentName nvarchar(60), @NewName nvarchar(100) OUTPUT
AS
BEGIN
DECLARE @d as datetime
SET @d = getutcdate()+3
SELECT @NewName = @CurrentName +'-'+ convert(char(8),@d,112)+'-'+ replace(newid(),'-','')
END