USP_SYSTEMROLE_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@ROLENAME	nvarchar(255)	IN
@DESCRIPTION	nvarchar(max)	IN

Definition

Copy



create procedure dbo.USP_SYSTEMROLE_ADD
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,    
    @ROLENAME nvarchar(255), 
    @DESCRIPTION nvarchar(max)=''
)    
as

--adds a new SystemRole to the database

set nocount on;

declare @CURRENTDATE datetime
set @CURRENTDATE = GetDate()

if @ID is null
    set @ID = NewID()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output


--Create System Role
insert into dbo.[SYSTEMROLE]
    (
    [ID],
    [NAME], [DESCRIPTION],    
    [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED])

    values
    (@ID,

    @ROLENAME, @DESCRIPTION,

    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

if @@error <> 0 return -7;

return  0;