July 17, 2008 at 3:45 am
Hi,
one of my co-worker suddenly pinged me and asked 'do you have isql/w installed in your PC ? ' , i said , i am hearing this word first time, sorry ! i don't have that.
After searching on websites, i came to know ISQL/W came along with SQL6.5. Am i right ?
I am curious to know where the name ISQL/W came from.
what is the difference between isql and isql/w ?
is it available in market now ?
karthik
July 17, 2008 at 4:53 am
ISQL/W is actually Query Analyzer.
ISQL is the earlier command line interface for doing the same thing as Query Analyser (i.e running queries and getting back results)
July 17, 2008 at 6:54 am
Between the query window in Management Studio and the command line options available through sqlcmd.exe, anything you can do with isql.exe is very old hat indeed. They're either just using old terminology for new tools, or they're one of those people with one year of experience repeated 15 times.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 17, 2008 at 7:46 pm
Ian Scarlett (7/17/2008)
ISQL/W is actually Query Analyzer.ISQL is the earlier command line interface for doing the same thing as Query Analyser (i.e running queries and getting back results)
Not true... ISQL does not have the same capabilities as Query Analyzer... OSQL in SQL Server 2000 is the command line equivalent to Query Analyzer. You should not use ISQL. 😉
And, yes... ISQL/W is Query Analyzer.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2008 at 9:02 pm
isql/w is a very simple/basic GUI. It is more like a text editor as I remember. It is not rich like query analyzer. The link below may help.
http://www.issociate.de/board/post/194409/isqlw.exe.html
isql (command line utility) is originally from Sybase, then OSQL, sqlcmd nowadays.
http://www.idevelopment.info/data/MSSQL/DBA_tips/Database_Administration/DBA_1.shtml
July 17, 2008 at 11:45 pm
Vivien Xing (7/17/2008)
isql/w is a very simple/basic GUI. It is more like a text editor as I remember. It is not rich like query analyzer. The link below may help.http://www.issociate.de/board/post/194409/isqlw.exe.html
isql (command line utility) is originally from Sybase, then OSQL, sqlcmd nowadays.
http://www.idevelopment.info/data/MSSQL/DBA_tips/Database_Administration/DBA_1.shtml
No, no.... ISQL/W IS Query Analyzer. ISQL.exe is something else... think of it as a crippled edition of OSQL.exe.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2008 at 11:02 am
isql/w is something like this:
http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
July 18, 2008 at 5:23 pm
Vivien Xing (7/18/2008)
isql/w is something like this:http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
Aghhh... My apologies... you are correct. Could even see the slash for the trees. :blush: Thank you for the correction, Vivien.
I meant to say that ISQLW.exe is Query Analyzer and that OSQL is the command line equivalent.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2008 at 8:10 pm
Jeff Moden (7/18/2008)
Vivien Xing (7/18/2008)
isql/w is something like this:http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
Aghhh... My apologies... you are correct. Could even see the slash for the trees. :blush: Thank you for the correction, Vivien.
I meant to say that ISQLW.exe is Query Analyzer and that OSQL is the command line equivalent.
Yeah, you are right. ISQLW.exe is Query Analyzer.
I used isql/w a few years ago. I felt embarrassing to work on old SQL Server that time. Now I can use my knowledge to gain point here. 😛
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply