SQL Query Analyzer (SQL2k) Bugs

Tested with SQL Server 2000 Query Analyzer SP4 with latest hotfixes. My PC is Windows 2000 Prof, with 2GB RAM, 2.8GHz processor.

First time I used it I got a .NET SQL connection handshake error. When you log in again all seems OK. However ...

Tab doesn't work for completion. Space only. This is contrary to intellisense in Visual Studio etc.

Type

SELECT * FROM dbo.

and then select table and this happens:

SELECT * FROM dbo.[dbo].[Contact]

Type

SELECT * FROM [dbo].[Process] WHERE p

, select ProcessID and press space and this happens

SELECT * FROM [dbo].[Process] WHERE p.[ProcessID]

Type

SELECT * FROM [dbo].[DepartmentsManagers] AS dm WHERE

, you can see the column DepartmentsManagersID, when you start to type dep.. the column disappears and all you have available is the table name "DepartmentManagers". It should just filter to columns beginning with Dep..??

Type

SELECT * FROM [dbo].[DepartmentsManagers] AS dm WHERE dm.[DepartmentsManagersID] = 1 AND dm.

and you get no intellisense for dm columns??

Type

UPDATE dep

and it lists columns starting dep as well as tables. Only tables/views are valid for UPDATE statements. If you select a column it does this

UPDATE ai.[department] FROM [dbo].[AD_Import] AS ai

which doesn't make any sense.

Type

SELECT *
FROM [dbo].[Request] AS r 
WHERE req

and it doesn't list RequestID which is a column in Request, in fact it only lists tables starting req

The support for completing joins based on foreign keys doesn't work as well as it used to

SELECT *
FROM [dbo].[Request] AS r 
  INNER JOIN [dbo].[RequestHistory] AS rh

doesn't pick up RequestID and complete the join

But type:

SELECT *
FROM [dbo].[Request] AS r 
  INNER JOIN [dbo].[RequestHistory] AS rh ON r.

and it does pick up the FK but it does this:

SELECT *
FROM [dbo].[Request] AS r 
  INNER JOIN [dbo].[RequestHistory] AS rh ON r.r.[RequestID] = rh.[RequestID]

It should replace the r. really.

Type

SELECT *
FROM [dbo].[Request] AS r 
  INNER JOIN

and it lists all sorts, columns etc, it should only list tables and views. You can't join a table to a column.

Type

SELECT *
FROM [dbo].[Request] AS r 
  INNER JOIN [dbo].[RequestHistory] AS rh ON r.[RequestID] = rh.[RequestID]
WHERE r.

and you get an exhaustive list of all sorts of useless entries rather than the columns of the Request table. Switch to columns view and it shows all columns of all tables rather than the only columns of tables used in the SELECT statement.
[/quote]