[dbo].[UpdateSequence]

(local) > mdb > Stored Procedures > dbo.UpdateSequence

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)	Direction
@CTRIN	char(20)	20
@OBJIDOUT	int	4	Out

Permissions

Type	Action	Owning Principal
Grant	Execute	harvest_group

SQL Script

CREATE PROCEDURE [dbo].[UpdateSequence] @CTRIN char(20), @OBJIDOUT int OUTPUT AS
UPDATE HARSEQTABLE
SET @OBJIDOUT = OBJID = OBJID +1 WHERE CTR = @CTRIN

GO
GRANT EXECUTE ON [dbo].[UpdateSequence] TO [harvest_group]
GO

Uses

[dbo].[HARSEQTABLE]
dbo