Comments
Sort by recent activity
Here's another one: select col1,
col2,
col3 as blah
from tbla
cross join
(
select col1, col2, col3
from tblb
) x
... becomes: select col1,
col2,
col3 as blah
from tbla
cross join ( select col1,
col2,
col3
from tblb
) x
But what I want is (based on the current behavior of the product in other cases): select col1,
col2,
col3 as blah
from tbla
cross join
(
select col1,
col2,
col3
from tblb
) x
/ comments
Here's another one:select col1,
col2,
col3 as blah
from tbla
cross join
(
select col1, col2, col3
from tblb
) x
... becomes:select col1,
col2,
col3 ...
Agreed! An option to automatically capitalize all keywords would be excellent. / comments
Agreed! An option to automatically capitalize all keywords would be excellent.
Another thing that would be cool:
CREATE TABLE Xyz
(
Xyz_Id INT NOT NULL,
myColumn VARCHAR(20)
)
...
select * from xyz where mycolumn = 'abc'
==
SELECT * FROM Xyz WHERE myColumn = 'abc'
(in other words, correct the capitalization for user-defined objects based on the capitalization actually used) / comments
Another thing that would be cool:
CREATE TABLE Xyz
(
Xyz_Id INT NOT NULL,
myColumn VARCHAR(20)
)
...
select * from xyz where mycolumn = 'abc'
==
SELECT * FROM Xyz WHERE myColumn = 'abc'
(in other w...
Just re-tested on the new beta, and unfortunately none of the issues mentioned in my original post have been fixed [image]
Looking forward to version 3.0! / comments
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!
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 [image] / comments
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 ...
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. / comments
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 "...
... 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 [image] / comments
... 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 t...
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". / comments
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".
... and still more comments [image]
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. / comments
... 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 ite...
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)) / 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 (SELE...