March 24, 2008 at 1:03 am
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
Using isql command, you can connect to sqlserver
March 25, 2008 at 7:59 am
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
osql for SQL Server 2000 and SQLCMD for SQL Server 2005 are what you should use.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply