Results 1 to 3 of 3

Thread: Sql Script

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    1

    Sql Script

    How to execute a Sql Script file Using Vb 6.

  2. #2
    Frenzied Member
    Join Date
    Aug 2005
    Posts
    1,042

    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

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    17,882

    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.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width