Search found 4 matches

by steelstorm
03 Oct 2013 14:18
Forum: DOS Batch Forum
Topic: Batch to run SQL script
Replies: 7
Views: 3160

Re: Batch to run SQL script

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
by steelstorm
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...
by steelstorm
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
by steelstorm
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...