how to run a .sql file in sql query analyser

[mkey]

Hi All,
In oracle one can run a script file with a .sql extention like:
start c:\myscript.sql

How do you do something similar in sql server 7.0?

thanks

 

[MissTipps]

Just open the .sql file from within query analyser, then either click the green arrow on the toolbar, or hit F5 to run the code.

You will then get a message in the results pane below informing you of the success (or otherwise) of the code.

 

[tlbroadbent]

You can also use the OSQL utility to execute .SQL files from the command line.

http://msdn.microsoft.com/library/en-us/coprompt/cp_osql_1wxl.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.