Stored procedure -> DOS Batch file -> OSQL -> SP communication.

Stored procedure -> DOS Batch file -> OSQL -> SP communication.

Post by U1FMQ2F0e » Tue, 26 Apr 2005 15:58:01


Hello,

How can I achieve the following?

Have a batch file that will get executed from a stored procedure using
xp_cmdshell.
The batch file will call another stored procedure using OSQL.
The stored procedure (after its processed the data) returns a number.
Further process flow in the batch file will depend on the value of the above
number.
How can I trap the return value from the stored procedure in the batch file?

Cheers!
SQLCatZ
 
 
 

1. >>>>>>>>>>>>>>>>>>>>>>>>>>>>test - no reply - ignore

2. >>>>>>>>>>>>Index.dat

On my computer there is a file called index.dat which is
uses by IE so when i try to delete it it says that you
can't. I know that i can delete it if i go into DOS but
if i do delete it what would happen?

Yhe reason i want to delete is that i read somewhere that
i has all your browsing history in it. Could you also
tell me what the file is used for. if that is not what it
is used for.

3. <>>>>>>>>>>>>>>>>>>>>>>>?

4. forward without >>>>>>>>>>>

5. >>>>>>>>>>>>>>>>>>> Visual C++ 2005 Express-----------------------

6. ==========================>>>>>>>>>>>>>>>>>>> AS/400 controller PERLE 494 for sale

7. vertical alignment>>>>>>>>>>

8. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

9. >>>>>>>>>>>>>>>>>>>

10. Need Help >>>>>>>>>

11. MS Mail for Office 2003>>>>>>>>>

12. >>>>>>>>>>>>>>>>>100% FREE GUIDE ON ANY KIND OF LOANS

13. PLEASE HELP>>>>>>>>>>>>>>>>>>

14. >>>>>>>>Start Receiving Unlimited Payments TODAY >>>>>>>>

15. >>>>#### >>>> Make BILLIONS Online Without Investment >>>#####>>>>>