-
Apr 27th, 2006, 01:06 AM
#1
Thread Starter
New Member
Sql Script
How to execute a Sql Script file Using Vb 6.
-
Apr 27th, 2006, 04:26 AM
#2
Frenzied Member
Re: Sql Script
Samarendra:
Welcome to VB Forum.
How to execute a SQL Script file.
What is an SQL Script file?
Do you mean a SQL Query such as:
Select * From xxx ?
I think you need to tell us a little bit more such as what type of database you are using and what kind of information you want to retrieve from the database.
Give a little more information and I am sure someone can help you.
Thanks
-
Apr 27th, 2006, 06:32 AM
#3
Re: Sql Script
We use only .SQL script files - these are notepad-like text files typed into QUERY ANALYZER and SAVED - .SQL is the file extension of these files.
Is this what you are referring to?
The OSQL command (DOS-command line) will process these .SQL files - run them into a server as if you are in QA and executing them
You could SHELL the OSQL command to run the .SQL script.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|