SQL Server insert script using cmd prompt

[Rishav]

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

[/dev/null]

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

[Rishav]

Thanks Kurt.

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