Results 1 to 6 of 6

Thread: isql Help

  1. #1
    Join Date
    May 2004
    Location
    Ohio
    Posts
    61

    Unanswered: isql Help

    Hello all, I'm new to the board...

    I'm trying to run a script in isql with a file that contains create database statements and I'm completely lost. If someone could help me and point me in the right direction, please!

    Thank you

  2. #2
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    23
    Can you please explain a little bit more of your problem with creating a database with a scipt?

    Sneaky Pie

  3. #3
    Join Date
    May 2004
    Location
    Ohio
    Posts
    61
    Hi Sneaky,

    I've created a .sql file that contains statements that will create tables when executed. What I must do is come up with a command line that will use the file and create the tables from the command prompt. Any idea?

    Thanks
    Smitty

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    check BOL for isql it has explaination and good example

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The command line utility for executing SQL batch files is called OSQL. You can get a list of paramaters allowed for it by entering:

    OSQL -?

    ...at the command line. You can also look it up in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    May 2004
    Location
    Ohio
    Posts
    61
    Thanks for all the replies and the Help, I have it now..

Posting Permissions

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