executing querys from a batch file

[William Kossack]

Someone asked me a curious question.

Can I execute a query to sql server from a bat file? how?

If not is there a simple scripting laguage that this person might use to
drive his process that is similar to a dos bat file?

[Erland Sommarskog]

Re: executing querys from a batch file

William Kossack (kossackw@njc.o rg) writes:[color=blue]
> Someone asked me a curious question.
>
> Can I execute a query to sql server from a bat file? how?
>
> If not is there a simple scripting laguage that this person might use to
> drive his process that is similar to a dos bat file?[/color]

You can use the command-line tool OSQL for this.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[William Kossack]

Re: executing querys from a batch file

Can you point me to an example or somewhere to look online?

Erland Sommarskog wrote:
[color=blue]
>William Kossack (kossackw@njc.o rg) writes:
>
>[color=green]
>>Someone asked me a curious question.
>>
>>Can I execute a query to sql server from a bat file? how?
>>
>>If not is there a simple scripting laguage that this person might use to
>>drive his process that is similar to a dos bat file?
>>
>>[/color]
>
>You can use the command-line tool OSQL for this.
>
>
>
>
>[/color]

[Mike Epprecht \(SQL MVP\)]

Re: executing querys from a batch file

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_mta_01_5zxi.asp

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.n et

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"William Kossack" <kossackw@njc.o rg> wrote in message
news:11fktjioc9 cp78d@corp.supe rnews.com...[color=blue]
> Can you point me to an example or somewhere to look online?
>
> Erland Sommarskog wrote:
>[color=green]
>>William Kossack (kossackw@njc.o rg) writes:
>>[color=darkred]
>>>Someone asked me a curious question.
>>>Can I execute a query to sql server from a bat file? how?
>>>
>>>If not is there a simple scripting laguage that this person might use to
>>>drive his process that is similar to a dos bat file?
>>>[/color]
>>
>>You can use the command-line tool OSQL for this.
>>
>>
>>
>>[/color][/color]

[Mike Epprecht \(SQL MVP\)]

Re: executing querys from a batch file

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_mta_01_2q61.asp

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.n et

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"William Kossack" <kossackw@njc.o rg> wrote in message
news:11fktjioc9 cp78d@corp.supe rnews.com...[color=blue]
> Can you point me to an example or somewhere to look online?
>
> Erland Sommarskog wrote:
>[color=green]
>>William Kossack (kossackw@njc.o rg) writes:
>>[color=darkred]
>>>Someone asked me a curious question.
>>>Can I execute a query to sql server from a bat file? how?
>>>
>>>If not is there a simple scripting laguage that this person might use to
>>>drive his process that is similar to a dos bat file?
>>>[/color]
>>
>>You can use the command-line tool OSQL for this.
>>
>>
>>
>>[/color][/color]

[DosItHelp]

Re: executing querys from a batch file

For an example how to embed a SQL script within a batch script so that you end up with only one file look here:

http://dostips.cmdtips.com/DtCodeInterfacing.php