Posts
Sort by recent activity
Derived tables?
The biggest gap in the previous versions of SQL Prompt, in my opinion, was support for derived tables. Any plans to add support to this version? I use a lot of derived tables, CTEs, and the like ...
Popup selection auto-highlighting...
Typed the following:
USE tempdb
GO
Hit Enter.
Result on my screen:
USE tempdb
GOTO
I don't think the selection should be auto-highlighted when the popup comes up...
Annoyance: No candidates messes up typing flow
Type "USE tempdb" ... there are no candidates (since it's not displaying databases -- see my other post on that), and I have to hit enter TWICE to get to the next line. Very annoying. If there ar...
Initial comments
Install: Easy/painless
Launched SQLPrompt (end of the install checkbox) and a little icon appeared in my taskbar... but it doesn't do anything! Double-clicking does nothing, right-click gives me o...
LayOut: Weirdness with CTEs
I entered the following into an SSMS window:;with r as
(
select
)
select *
from tbl
where
I selected only the "select * from tbl where" section, and clicked LayOut. As expected, it thr...
Idea: normalization helper
Almost certainly for post v.1, but here's an idea I just thought of that I'd love to see:
Say the database has the following kind of table (unfortunately, all too common):CREATE TABLE Purchases
...
Split Table: Joining the resultant tables
If I create the following table:create table x1(id1 int, id2 int not null primary key, id3 int)
... and the following stored procedure:create proc getx
as
select *
from x1
... and spl...
Split Table: "Copy" vs. "Move"
I just tried to split HumanResources.Employee in AW, and copied BirthDate, Gender, and HireDate over to a new table -- but did not move anything. Yet, SQL Refactor wants to drop some triggers, mod...
LayOut comments
If I use LayOut on this:select * from tbla join tblb on tbla.id = tblb.id
I end up with this:select *
from tbla
join tblb on tbla.id = tblb.id
This one drives me crazy. There is no...
Initial comments
1) I'd like to see more options for selecting the chosen candidate. Spacebar, for instance, would be nice, and would align the product with the way intellisense in VS works.
2) In the WHERE clause...