USP_ADDCODETABLECATEGORY
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESCRIPTION | nvarchar(100) | IN | |
| @ChangeAgentID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_ADDCODETABLECATEGORY
@DESCRIPTION nvarchar(100),
@ChangeAgentID uniqueidentifier = null
with execute as caller
as
begin
if @ChangeAgentID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @ChangeAgentID output
insert into dbo.CODETABLECATEGORY (DESCRIPTION, ADDEDBYID, CHANGEDBYID) values (@DESCRIPTION, @ChangeAgentID, @ChangeAgentID)
end