Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: Get return value of Store procedure from batch  (Read 3196 times)

0 Members and 1 Guest are viewing this topic.

JDinku

  • Guest
Get return value of Store procedure from batch
« on: December 20, 2005, 06:50:19 PM »
Hi all,
How can I get return value of store procedure from batch file.

I can get reuturn value from SQL using EXIT(%query%).
But when I use EXIT("exec MyStore"). It cannot !

Please help me!

Thank you.
Logged

ghostdog74



    Specialist

    Thanked: 27
    Re: Get return value of Store procedure from batch
    « Reply #1 on: December 20, 2005, 11:45:23 PM »
    can post your code?
    Logged

    JDinku

    • Guest
    Re: Get return value of Store procedure from batch
    « Reply #2 on: December 26, 2005, 02:50:53 AM »
    Hi all,
    I have solved that problem.
    I ceated a view to store error code (the value that I want to return), and get error code from that view by using normal select.

    Thank you.

    « Last Edit: December 26, 2005, 02:52:17 AM by JDinku »
    Logged
    Pages: [1]   Go Up
    « previous next »