473,473 Members | 1,752 Online

Sign in
Join

Home Posts Topics Members FAQ

running script

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

thanx

Jul 20 '05 #1

Subscribe Reply

3

3857

"srdjan" <pr******@yahoo.com> wrote in message news:<bg**********@news.eunet.yu>...

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

Jul 20 '05 #2

CJ

If you encapsulate what you are calling a script into a stored procedure,
yes you can run it from a client app.
CJ
"srdjan" <pr******@yahoo.com> wrote in message
news:bg**********@news.eunet.yu...

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

thanx

Jul 20 '05 #3

yes, it's a .sql file

thank you
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:60**************************@posting.google.c om...

"srdjan" <pr******@yahoo.com> wrote in message

news:<bg**********@news.eunet.yu>...

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

Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

running php script?

by: Sticks | last post by:

ok... im not quite sure how to describe my problem. i have a php script that runs through my entire php site and writes the resulting output to html files. this is necessary as the nature of the...

Script stops running during while()

by: Damien Renwick | last post by:

I have a php script which simply stops midway through a while loop that processes records returned by a MySQL query. The HTML page continues trying to load the page but the php has stopped running...

Running script before import

by: shumaker | last post by:

I don't need a detailed description of a solution(although I wouldn't mind), but I am hoping someone could tell me in general the best path to go about accomplishing a task, since I don't know all...

Checking whether postgresql is running

by: Ennio-Sr | last post by:

Hi all! Testing a script where I need to make sure that postgresql is running before passing a <psql dbasename -c "insert into ..." > instruction I faced this curious behaviour: This is the...

modify a long-running python script while it is running?

by: Benjamin Rutt | last post by:

I often execute a long-running python script which is a "driver" for my application; it may run for several hours on a large input. Under CPython, is it safe for me to modify the Python script...

How to display progress bar for long running page in Javascript

by: Anonieko | last post by:

Query: How to display progress bar for long running page Answer: Yet another solution. REFERENCE: http://www.eggheadcafe.com/articles/20050108.asp My only regret is that when click the...

LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans

by: Aaron West | last post by:

Try this script to see what queries are taking over a second. To get some real output, you need a long-running query. Here's one (estimated to take over an hour): PRINT GETDATE() select...

connection drops while script running

by: This | last post by:

I have a pretty basic emailing script that sends a relatively small number (150) of html emails. The emails are compiled, personalised from a mysql db subscribers list, and sent using mail() -...

Determine folder a script is running in.

by: Scott | last post by:

What is the most reliable method to determine the folder a script is running in? I was looking at the globals in $_SERVER but all the variables also listed the actual file the script was running...

running same script on same data on two different machines -->different result

by: Christopher Brewster | last post by:

I am running the same script on the same data on two different machines (the folder is synchronised with Dropbox). I get two different results. All the script does is count words in different...

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us