Results 1 to 6 of 6

Thread: SQL-Query Analyzer

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Location
    y
    Posts
    141

    Unhappy

    Hi All
    How can i run SP in this tool
    For Exp: i have Sp with Name
    Get_Tom_Run
    This SP get 2 parameters
    1) user_name
    2)Friend_name

    How am i need to write it and get the resault

    Thanks
    Efrat
    [email protected]

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266
    You can do the following
    EXECUTE Get_Tom_Run user_name,friend_name

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Location
    y
    Posts
    141

    Thanks

    Thanks

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Location
    y
    Posts
    141

    Unhappy Not success

    Hi
    I try this but not success
    i try EXECUTE get_permitted_stations
    but the SP expects parameter '@v_user_name', which was not supplied.

    So what can i do?

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Location
    y
    Posts
    141

    Talking I did it ,I did It

    I did It thank you very much
    YUUUUUUUHOOOOOOOOOOOO

    Efrat

  6. #6
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    I've never seen someone so happy to call a stored procedure

    go Efrat go!

Posting Permissions

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



Click Here to Expand Forum to Full Width