Awesome. Thanks alot for the help. I believe from the info you have provided I should be able to get this working.
This is seriously going to cut about an hour out of my day I can spend on much more productive items.
Thanks again!
Phill
Search found 4 matches
- 03 Oct 2013 14:18
- Forum: DOS Batch Forum
- Topic: Batch to run SQL script
- Replies: 7
- Views: 3160
- 03 Oct 2013 11:34
- Forum: DOS Batch Forum
- Topic: Batch to run SQL script
- Replies: 7
- Views: 3160
Re: Batch to run SQL script
thanks for all the replies. The above example was exactly what I was looking to do. I use Sequel Server Management Studio to run any queries. I'm guessing this is the application you were needing info on to write the second step? I read up a little on the sqlcmd via a batch file and I'm guessing thi...
- 03 Oct 2013 10:36
- Forum: DOS Batch Forum
- Topic: Batch to run SQL script
- Replies: 7
- Views: 3160
Re: Batch to run SQL script
Below is the script itself I enter in. The parts in bold is what are constantly changing that the end user would need to enter themselves.
USE ExampleDataBase
exec DocumentsCopyVendorViewable @OrderNo=119997, @SourceItemNo=1, @DestItemNo=2
USE ExampleDataBase
exec DocumentsCopyVendorViewable @OrderNo=119997, @SourceItemNo=1, @DestItemNo=2
- 03 Oct 2013 09:54
- Forum: DOS Batch Forum
- Topic: Batch to run SQL script
- Replies: 7
- Views: 3160
Batch to run SQL script
Hi all, I am looking for help to run a SQL query from a batch file. I mainly just do helpdesk for pc issues so this is starting to get a little over my head. The main reason I want to do this is because I basically get about 40 tickets a day to run this script, and I thought if a batch file could be...