How can we help you today? How can we help you today?

EXEC Stored Procedure with output parameters

The following is code produced for an exec of a stored procedure.

Even though all of the stored procedure parameters are declared as OUTPUT params SQLPROMPT has inserted the parameters expecting me to fill them in.


EXEC [Sales].[GetOrderNumber]
@SOPNumber = ?, -- int
@err = ? -- nvarchar

What i really want is

EXEC [Sales].[GetOrderNumber] @SOPNumber OUTPUT, @err OUTPUT

Is this possible? It would prevent me from having to delete the extra code inserted by SQLPrompt when ever I exec a stored proc in mangement studio

regards

Zac
zac
0

Comments

1 comment

Sort by
  • Bart Read
    Hi zac,


    Yes that's a bug. I'm filing it now and will make sure it's fixed for the final release.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.