running script

#1

Is it possible to run SQL certain script from the client application ?

thanx

#2

"srdjan" <priki_ns (AT) yahoo (DOT) com> wrote

Quote:

Is it possible to run SQL certain script from the client application ?

thanx

I'm not sure what you mean by a SQL "script". If you mean a .sql file,
then you can call osql.exe to execute it, or perhaps read the file
into a string variable and execute it from your client library as an
ad hoc query (using ODBC/ADO etc.).

Simon

#3

If you encapsulate what you are calling a script into a stored procedure,
yes you can run it from a client app.
CJ
"srdjan" <priki_ns (AT) yahoo (DOT) com> wrote

Quote:

Is it possible to run SQL certain script from the client application ?

thanx

#4

yes, it's a .sql file

thank you

"Simon Hayes" <sql (AT) hayes (DOT) ch> wrote

Quote:

"srdjan" <priki_ns (AT) yahoo (DOT) com> wrote

Is it possible to run SQL certain script from the client application ?

thanx

I'm not sure what you mean by a SQL "script". If you mean a .sql file,
then you can call osql.exe to execute it, or perhaps read the file
into a string variable and execute it from your client library as an
ad hoc query (using ODBC/ADO etc.).

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

running script

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

running script - 08-04-2003 , 04:55 AM

Re: running script - 08-04-2003 , 07:45 AM

Re: running script - 08-04-2003 , 04:53 PM

Re: running script - 08-05-2003 , 12:48 AM