Hi, I'm a beginner using MS SQL 6.5. I need to seek help on some of the questions below:
1) How do I make use of ISQL and BCP to extract the results of a stored procedure to an Excel file format?
2) How do I create a stored procedure?
3) How do I create a batch file to run the query every day?
Kindly put in examples to simplify your help.