7 results found
-
Column Order when expanding pivot is reversed
I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
e.g.
If I have something with a pivot
Sum(Amount) for month_no in ([1],[2],[3]....)
When the pivot result is expanded, it becomes [12],[11],[10]....
Would be nice if the expansion would match the order that the columns was entered in.1 vote -
Allow searching with regex in "SQL Search"
Currently it is hardly possible to search for column assignments like "Column1 = 0". The results include any words having zero.
This request is similar to the "allow multiple keywords searches", but it is for a button named "SQL Search" instead of "Tab History".
Either treat "match whole words only" as the entire search text entered is matched exactly or introduce another checkbox "Search as Regex" to handle this scenario.
1 vote -
Optional column alias when expanding wildcards
When SQL Prompt gives you the option to expand wildcards by typing a TAB, can you make it possible to add a modifier key (say Alt-TAB or Ctrl-TAB) that will generate aliased column names based on the table name?
For example, on an insert or update statement, we can use the OUTPUT clause to capture the changes made to a table. So, currently, typing Deleted.* and pressing TAB will generate columns such as
Deleted.Id,
Deleted.ModifiedDate,
Deleted.Description
and so on.It would be more useful to have
Deleted.Id as DeletedId,
Deleted.ModifiedDate as DeletedModifiedDate,
Deleted.Description as DeletedDescription8 votes -
Can we have a keyboard shortcut for "Script Object as ALTER"?
Can we have a keyboard shortcut for "Script Object as ALTER"? You had it before but it isn't available with the latest version.
2 votes -
Expand Wildcards with alias and equal sign
When I expand Wildcards I would like it like
Select col1 = tb.col1
col2 = tb.col2
FROM tb4 votes -
Add $Query$ to execute when inserting a snippet
Add $query$ to SQL prompt that allows you to define a query which get executed and the results pasted in place, optionally formatted as VALUES statement
I currently have a snippet that runs
SELECT '(' + CAST(r.RegionId AS VARCHAR(50)) + ',''' + r.RegionDescription + ''',0),'
FROM retail.Regions r
WHERE r.ActiveTo > GETDATE()
ORDER BY r.RegionDescriptionI then copy the output and use the $paste$ place holder in another snippet to paste in
DECLARE @regions TABLE (RegionId INT, RegionDescription VARCHAR(50), Active bit)
INSERT @regions (RegionId, RegionDescription, Active)
VALUES
--$PASTE$ goes here
(117,'Anglia',0),
(119,'Greater Manchester',0),
(145,'Hampshire',0),An improvement would be remove the…
2 votes -
INSERT INTO Wildcard
When doing an INSERT INTO it would be nice if you could type INSERT INTO TableName (*) then if you tabbed after the * it would expand out all the columns for that table.
9 votes
- Don't see your idea?