Initial comments

• 
  And yet another spacebar quirk:
  
  - SELECT * FROM
  - Hit spacebar
  - Hit escape
  - Hit spacebar again
  
  I'm not sure if that's intended..?
  
  Also, it would be nice if the product supported table hints (SELECT * FROM Tbl WITH (xxx))

  amachanic May 01, 2006 14:00

  - 0 +
• 
  ... and still more comments
  
  Can the product be made to support column names in the SELECT list?
  
  And how about some better support for GROUP BY? I'd like to see a candidate list where the top items are all of the unaggregated columns from the SELECT list.

  amachanic May 01, 2006 14:02

  - 0 +
• 
  ... last one for now!
  
  
  The following sort-of works:
  
  select *
  from
  (
  select abc
  from tbl
  ) x
  where x.
  
  This lets me choose column "abc" from the derived table. It would be nicer if I didn't have to type "x." to get the column list, but that's something I can live with.
  
  However, this does not work for CTEs at all:
  
  ;with x as
  (
  select abc
  from tbl
  )
  select *
  from x
  where x.
  
  ... No column list here

  amachanic May 01, 2006 14:07

  - 0 +
• 
  OK, I lied. Just found a bug:
  
  
  select *
  from
  (
  select abc
  from tbl
  ) x (def)
  where x.
  
  
  This brings up "abc" as the column name, even though it should be "def".

  amachanic May 01, 2006 14:08

  - 0 +
• 
  Back again with even more...
  
  1) Type in:
  
  if 1=1
  begin
  exec
  
  This brings up a list of tables, rather than stored procedures.
  
  2) Type in:
  
  INSERT
  
  This does not bring up a list of tables unless I type "INSERT INTO" -- how about the first thing on the list after typing INSERT being "INTO", followed by a list of tables? Same problem exists for DELETE (FROM).
  
  3) Type in:
  
  INSERT Tbl (
  
  How about a list of columns for Tbl?
  
  4) Type in:
  
  UPDATE Tbl
  SET
  
  Again, a list of columns would be nice.
  
  
  5)
  
  UPDATE Tbl
  SET x = 1
  WHERE
  
  ... No list of columns here, either.
  
  
  6) UPDATE FROM syntax is not supported properly:
  
  update tbl
  set x=1
  from
  
  This brings up a list of scalar functions and column names, not a list of tables.

  amachanic May 01, 2006 16:04

  - 0 +
• 
  All the behaviors you mention, especially the "where's my cursor gone???" were in the original product.
  
  Have you noticed how Query Analyzer suddenly goes on a "go slow" for no good reason? Tabbing from a newline in the middle of a chunk of existing code seems to provoke this more often than not. Each tab takes a second to "get back to you" - not a productivity aid

  PDinCA May 01, 2006 16:33

  - 0 +
• 
  Hopefully they'll clean up the product a bit before selling it as version "2.0"! ... but I assume that's why this forum is here.
  
  As for slowness, QA is like a lightning bolt compared with the dog that is SSMS...
  
  Here's a fun SSMS trick:
  
  1) Hit CTRL-M (include actual execution plan)
  
  2) type:
  
  ---
  select *
  from master.sys.databases
  
  waitfor delay '00:00:30'
  ---
  
  3) Hit F5 (Execute)
  
  ... wait 30 seconds before the product comes back to life

  amachanic May 01, 2006 16:38

  - 0 +
• 
  Thanks for all the feedback. Keep it coming!

  Neil Davidson May 01, 2006 16:41

  - 0 +
• 
  If I'm typing one of the "capitalize" words and I happen to be in a literal, the tool SHOULD NOT capitalize. It does in v1.4.
  
  As I've reverted to 1.4 for daily use, I can't actually verify this behavior is fixed without some down time - can't afford it, sorry
  
  Is this bug fixed?

  PDinCA May 02, 2006 12:34

  - 0 +
• 
  Just re-tested on the new beta, and unfortunately none of the issues mentioned in my original post have been fixed
  
  Looking forward to version 3.0!

  amachanic May 19, 2006 12:25

  - 0 +

Add comment

Please sign in to leave a comment.