USP_GETREVENUEDEFAULTUSERDEFINEDID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @USERDEFINEDID | nvarchar(100) | INOUT |
Definition
Copy
create procedure USP_GETREVENUEDEFAULTUSERDEFINEDID(
@ID uniqueidentifier
,@USERDEFINEDID nvarchar(100) output
)
as
begin
declare @NEWSEED bigint;
insert into dbo.IDGENREVENUE ( ID ) values (@ID)
;
select @NEWSEED = scope_identity();
select @USERDEFINEDID = 'rev-' + cast(@NEWSEED as nvarchar(max));
end;