Connecting to SQL Server via a bat file

• cyan_d

  Valued Member

  Points: 69

  More actions

  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!

• Bilichi

  Right there with Babe

  Points: 741

  More actions

  March 24, 2008 at 3:44 am

  #792941

  Using isql command, you can connect to sqlserver

• steve block

  SSCertifiable

  Points: 7698

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  March 25, 2008 at 8:25 am

  #793520

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