spUpdateRevision

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@VCURRENT	int	IN
@V1	int	IN
@V2	int	IN
@V3	int	IN
@V4	int	IN
@V5	int	IN
@V6	int	IN
@V7	int	IN
@V8	int	IN
@V9	int	IN
@V10	int	IN
@V11	int	IN
@V12	int	IN
@V13	int	IN
@V14	int	IN
@V15	int	IN
@V16	int	IN
@V17	int	IN
@V18	int	IN
@V19	int	IN
@V20	int	IN
@V21	int	IN
@V22	int	IN
@V23	int	IN
@V24	int	IN
@V25	int	IN
@V26	int	IN
@V27	int	IN
@V28	int	IN
@V29	int	IN
@V30	int	IN
@V31	int	IN
@V32	int	IN

Definition

Copy




CREATE PROCEDURE spUpdateRevision
(
    @ID         int OUTPUT,
    @VCURRENT   int,
    @V1         int,    @V2         int,    @V3         int,    @V4         int,    @V5         int,
    @V6         int,    @V7         int,    @V8         int,    @V9         int,    @V10         int,
    @V11         int,    @V12         int,    @V13         int,    @V14         int,    @V15         int,
    @V16         int,    @V17         int,    @V18         int,    @V19         int,    @V20         int,
    @V21         int,    @V22         int,    @V23         int,    @V24         int,    @V25         int,
    @V26         int,    @V27         int,    @V28         int,    @V29         int,    @V30         int,
    @V31         int,    @V32         int
)
AS

UPDATE
    Revisions
SET
    VCURRENT = @VCURRENT,
    V1 = @V1, V2 = @V2, V3 = @V3, V4 = @V4, V5 = @V5, V6 = @V6, V7 = @V7, V8 = @V8, V9 = @V9, V10 = @V10,
    V11 = @V11, V12 = @V12, V13 = @V13, V14 = @V14, V15 = @V15, V16 = @V16, V17 = @V17, V18 = @V18, V19 = @V19, V20 = @V20,
    V21 = @V21, V22 = @V22, V23 = @V23, V24 = @V24, V25 = @V25, V26 = @V26, V27 = @V27, V28 = @V28, V29 = @V29, V30 = @V30,
    V31 = @V31, V32 = @V32
WHERE
    ID = @ID