Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Sep 2012
    Posts
    76
    Thanks
    61
    Thanked 0 Times in 0 Posts

    Stored procedures (inout)

    Hello, I'm trying to learn about stored procedures and I am stuck on using a stored procedure with inout

    Now I can't find a good example of how to use inout on a web search. I can find loads on in, loads on out but not inout

    Can anyone help me here please with a simple demo query? Thank you.
    Last edited by Oatley; 03-27-2013 at 08:18 PM.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,965
    Thanks
    79
    Thanked 4,429 Times in 4,394 Posts
    Personally, I would never use an INOUT. I think it just leads to confusion.

    If you think you need an INOUT, just use two parameters instead, on IN and one OUT.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • Users who have thanked Old Pedant for this post:

    Oatley (03-27-2013)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •