Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azreen
Starting Member
2 Posts |
 Posted - 2010-12-06 : 00:26:44
|
| Dear all developer,i'm new here and have question about bat file.i have 1 file named as LOT.dat. This file i want it to automatically insert to SQL table named as LOT_SAP after delete existing data on it by using bat command.any ideas how to do? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-06 : 04:38:20
|
| Have a look at sqlcmd (the replacement for osql and isql). It's a command line utility that allows you to connect to sql server and execute commands.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
azreen
Starting Member
2 Posts |
Posted - 2010-12-06 : 04:59:11
|
| Nigel,what is the right sqlcmd to use for this?sorry, i'm still new with SQL and need help for this |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-06 : 05:13:50
|
| sqlcmd is a command line utility.It can take an sql statement which it can execute against a server. Can also take an input file of commands.Have a look in bol.Another option might be to create an ssis package which you can then call from a dtexec command in a bat file - but sqlcmd would be more lightweight.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
delete and insert into SQL table using bat file