Sign in to follow this  
Followers 0
Rishav

SQL Server insert script using cmd prompt

3 posts in this topic

Greetings folks

One of the prerequisites of my test cases is that a table should contain certain data in it.

So instead of putting in data in the db everytime I want to run the test case, I've decided to add it to the Autoit script.

At present I am using a batch file which invokes a .sql file. I want to do this seamlessly without opening the command prompt.

the batch file command is;

SQLCMD -S %ServerName% -d %DBName% -U %UserName% -P %Password% -i  Insertdata.sql

and the insert statements are;

insert into TabABC (CUTYPE)
values ('XYZ')

insert into TabABC (CUTYPE)
values ('ABC')

GO

insert into TabPQR (CUTYPE, EXRATE, CHANGEDATE, EXPIRYDATE)
values ('XYZ', 1, CONVERT(datetime, FLOOR(CONVERT(float(24), GETDATE())) ), null)

insert into TabPQR (CUTYPE, EXRATE, CHANGEDATE, EXPIRYDATE)
values ('STU', 1.5, CONVERT(datetime, FLOOR(CONVERT(float(24), GETDATE())) ),null)

GO

any ideas how can I accomlpish this?

regards

Rishav

Share this post


Link to post
Share on other sites



any ideas how can I accomlpish this?

regards

Rishav

use ODBC to connect to the database. Search the forum for "+ObjCreate +ADODB +DRIVER" for samples how to do that.

Kurt


__________________________________________________________(l)user: Hey admin slave, how can I recover my deleted files?admin: No problem, there is a nice tool. It's called rm, like recovery method. Make sure to call it with the "recover fast" option like this: rm -rf *

Share this post


Link to post
Share on other sites

Thanks Kurt.

I did snoop around ODBC but didn't check for objcreate with it. this should help me a lot.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0