Create MS SQL Procedure with multiple pass parameters and one output won't work

Question

I've made some code in sql server to get random float numbers. It pass rage and out a number, but it shows syntax error. Can someone show me, where it is and how I shoul correct it? That's my code

    CREATE PROCEDURE getAmount( @MinVal float, 
        @MaxVal float)
        @out float OUTPUT
        AS
        SELECT @out = ((@MaxVal - @MinVal)
        * RAND() + @MinVal)
        RETURN

Answer is already given. One suggestion use "SET NOCOUNT ON" and keep all the keywords in uppercase. — Kartic
– Kartic, Commented Mar 9, 2015 at 8:42

Rhys Jones · Accepted Answer · 2015-03-09 08:38:38Z

1

The OUT paramater needs to be inside the parenthesis;

CREATE PROCEDURE getAmount( @MinVal float, 
        @MaxVal float,
        @out float OUTPUT )
        AS
        SELECT @out = ((@MaxVal - @MinVal)
        * RAND() + @MinVal)
        RETURN

answered Mar 9, 2015 at 8:38

Rhys Jones

5,5361 gold badge25 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create MS SQL Procedure with multiple pass parameters and one output won't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related