write SQL insert, update and delete commands in a batch file

Question

Can I write SQL insert, update and delete commands in a batch file? If I can do so can someone give me an example please.

Dibakar Paul · Accepted Answer · 2016-05-16 09:40:36Z

1

write the sql code and save as .sql extension. (code.sql) then call it from a batch file, eg @echo off sqlcmd -S <ComputerName>\<InstanceName> -i code.sql

Save this as a *.bat file.

edited May 16, 2016 at 9:40

Dibakar Paul

1661 silver badge11 bronze badges

answered May 16, 2016 at 9:28

Lithin Kuriachan

338 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sarah117 Over a year ago

Can you please explain me how can I get the InstanceName here?

Lithin Kuriachan Over a year ago

it is your Database instance name eg :- 'database1'

Sarah117 Over a year ago

Thanks. But how do you know whether your sql commands have worked properly?

Collectives™ on Stack Overflow

write SQL insert, update and delete commands in a batch file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related