Sam,

In Query analyzer, use the mouse and go to file and then open and open the file you want.
In osql, do:
:r thenameofthefile <enter>


Execute it with
go <enter>

Unfortunately, I don't know of a nice way to edit it in osql as I don't use it much - however, I have not researched it so perhaps there is a way. I only guessed about the :r because it is that way in sybase's isql utility. (:r is like the ed/vi command to read a file)


On 02/19/2002 01:33:33 AM Sam Sairlao wrote:
> Hi DBA Guru,
>
> I am new to SQL Server environment.
>
> How do I load sql statement from sql file  in Query analyser or Osql
> utilities?
>
> Thanks a million.
>
> Sam---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed] . . Tom

Tom Zeblisky
Reuters





-----------------------------------------------------------------
Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
MS Sql Server LazyDBA home page