How do I execute a .sql file from command promt

How do I execute a .sql file from command promt?
I googled and couldnt find a clue about it...
Please help

Quote:

Originally Posted by Bangaru

How do I execute a .sql file from command promt?
I googled and couldnt find a clue about it...
Please help

im not 100% sure, but i think you just type in the location of the file|||

Quote:

Originally Posted by Bangaru

How do I execute a .sql file from command promt?
I googled and couldnt find a clue about it...
Please help

you can use isql and osql command lines for accomplishing this .. you can also pass the server name and other parameters ..

for more info pls check sql books online ..|||see books online for isql utility|||

Quote:

Originally Posted by siva538

you can use isql and osql command lines for accomplishing this .. you can also pass the server name and other parameters ..

for more info pls check sql books online ..

Note, you will need to have the Client Tools installed (I'm a real idiot sometimes).