Post reply

Connecting to SQL Server via a bat file

  • March 24, 2008 at 1:03 am

    #379346

    I am new to SQL Server and wonder if there is a way to connect to SQL Server to query data via a bat file. I know I can use SQLPLUS for Oracle, what about SQL Server?

    Thanks!

  • March 24, 2008 at 3:44 am

    #792941

    Using isql command, you can connect to sqlserver

  • March 25, 2008 at 7:59 am

    #793503

    Are you using 2005? I'm in the process of learning for switching from 2000 but according to 2005 BOL, isql is no longer supported and sqlcmd should be is used for 2005. isql is even old for 2000 but can be used. osql is the tool the supports all the features of 2000.

    Steve

  • March 25, 2008 at 8:25 am

    #793520

    osql for SQL Server 2000 and SQLCMD for SQL Server 2005 are what you should use.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply