ISQL/W

Question

ISQL/W

karthik M

One Orange Chip

Points: 29139
More actions
July 17, 2008 at 3:45 am

#103535

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

Viewing 9 posts - 1 through 8 (of 8 total)

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

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 1

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)

Grant Fritchey SSC Guru Points: 398716 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1003913 More actions · Answer 3

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vivien Xing SSChampion Points: 12297 More actions · Answer 4

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

Jeff Moden SSC Guru Points: 1003913 More actions · Answer 5

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vivien Xing SSChampion Points: 12297 More actions · Answer 6

isql/w is something like this:

http://www.imranweb.com/freesoft/

"For more information on Enhanced ISQL/w, read this document. "

isql/w != isqlw

Jeff Moden SSC Guru Points: 1003913 More actions · Answer 7

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vivien Xing SSChampion Points: 12297 More actions · Answer 8

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. 😛