674 results found
-
Check is left and right are the same, and always true: like Where [Column]=[Column]
Check if left and right are the same, and so always true:
like Where [Column]=[Column]
or Where @var1 = @var 1 ..this is a big mistake .. just happened to me ..
5 votes -
Share tabs between clients
Currently I'm onboarding a new laptop. I've been given a few weeks to offboard my old laptop so I'm working between the two. Additionally I sometimes work on a jump-box.
All 3 of these instances are logged in with my SQL Prompt credentials. I have a solution for sharing my Snippets, Connection Coloring, and Styles between these machines. However it would be nice also if I could re-open a tab from my old laptop on the new laptop (or the jump box) as and when I'm switching between machines.
5 votes -
Option to align AND conditions with ON clause
Would love to have the option to have all conditions (AND / OR) aligned (or same indentation) with the ON clause, for example:
FROM dbo.orders AS o
JOIN dbo.orderAttributes AS oa
~~ON oa.companyID = o.companyID
~~AND oa.orderID = o.orderID5 votes -
Secure tab history
Either detect and scrub passwords from tab history, or store the history files securely so they can't be copied by backup software and viewed as plain text on the drive without a password.
5 votes -
Warn against reserved words in column names
Consider a table
CREATE TABLE [dbo].[ItemGroups](
[Group] [VARCHAR](25) NOT NULL,
[Description] [VARCHAR](25) NOT NULL)SELECT Group from dbo.ItemGroups ->
Incorrect syntax near the keyword 'Group'.
Would be nice to get a warning when a column name is a reserved word. Square brackets make the syntax valid but unnecessary if a column is named more accurately, e.g. ItemGroupCode
5 votes -
Separate ALIAS Alignment - table vs. column
Aligning based on column-alias makes for much better readability. When turned OFF, because some long-named table's alias pushes the TABLE-alias way to the right, all other table aliases follow it...into the NON-VISIBLE area (when using multiple vertical tabs).
Please SEPARATE these into TWO options:
. Align Column Aliases - on/off
. Align Table Aliases - on/offTHERE IS A BUG TO FIX HERE TOO: If a UDF is bounded by "--SQL Prompt formatting off/on" the TABLE ALIAS position REMAINS as if the UDF's alias was in it's SQL Prompt position, NOT where the excluded code has it! NASTY.
You could…
5 votes -
Tab History - Closed tabs
It would be nice to have an ability to use either CTRL + click and SHIFT + click combos or to have check boxes there in order to select multiple closed scripts for a removal from Tab History instead of repeatedly hitting Remove context menu choice. It should save developer's time. Check boxes would be even better implementation choice, because that way you can apply context menu choice to a selection of scripts. Yay!
Thanks!5 votes -
Copy as IN clause - Allow second column as ID comment
So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…
ProductID ProductDesc
1 SQL Prompt
2 SQL Search
3 SQL CompareIf we use Copy as IN Clause on the ProductID column, we get:
IN
(
1,
2,
3
)Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:
IN
(
1, -- SQL Prompt
2,…5 votes -
Don't add trivial queries
Add an option to filter what tabs are moved into history.
- SSMS autogenerated queries are of no interest.
- So are simple DML and EXEC[UTE] queries consisting of one statement.
- Successful executed ALTER {PROC|VIEW} are of no interest.
Optionally calculate a query complexity value or class to hide simple queries.
5 votes -
Tab ageing - automatic deletion after X days / weeks / months
Add a configuration option to automatically delete tabs by age (last executed or tab closed).
Or move them outside the normal tab history (archive them) to speed up the normal history loading and searching.
5 votes -
Script object as alter also in 'CREATE OR ALTER' statement
'Script object as alter' (F12) works in ALTER statements but not in CREATE OR ALTER statements like. It would be nice if it also worked for the latter.
Example:
'CREATE OR ALTER VIEW [MyView] AS SELECT 1 AS Col1;'
If I right-click on [MyView] in the above code snippet and select 'Script object as ALTER' (or hit F12), I would expect SQL Prompt to script the object if it exists.
Currently nothing happens.5 votes -
untabify
When saving/opening file automatically untabify it.
(select all then edit|advanced|untabify selected lines)
Some how, some way, despite telling everyone to set convert tabs to spaces we constantly get tabs in our SQL code. It would be really nice to just have it automatically convert to spaces so I can save a few clicks.
5 votes -
Cross symbol to Close Tab (and don't jump away afterwards)
I'm a "messy" developer who leaves dozens of tabs open while I'm working on a project, only occasionally doing a bit of a spring clean by closing what I don't need. I only just realised I can do this in Tab History by filtering for Open tabs and right-clicking on a tab entry and choosing Close from the context menu. And I love the fact that I get a preview just by hovering over the name so I can quickly decide whether or not to close each tab.
I would like to see a cross (close) symbol added to the…
5 votes -
Import and Export Aliases
It would be nice to have the ability to mass import/export aliases.
5 votes -
REOPEN CLOSED TAB
I'd like to see a right-click on a tab or the tab-bar and have the option to "reopen closed tab" (and the ability to do that several times through working back through the order the tabs were closed). Same functionality as the major web browsers have.
5 votes -
Insert Default Values should include default values defined on the table.
For example, if a table is defined as such :
CREATE TABLE dbo.T1 (
col1 INT DEFAULT 100,
col2 VARCHAR(100) DEFAULT 'Example',
col3 DATETIME DEFAULT '01/01/2019'
)And use auto-complete to generate and INSERT, it will produce :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 0 -- col1 - int
,'' -- col2 - varchar(100)
,GETDATE() -- col3 - datetime
)Instead, it would be nice to have it produce the insert with the defined table default's, something like :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 100 -- col1 - int
,'Example' -- col2 - varchar(100)
,'01/01/2019…5 votes -
Support SSDT for SQL Prompt
Create Install Package for installing SQL Prompt in SSDT. SSDT is a VS shell, so Prompt should be easily incorporated.
5 votes -
Shortcut to move commas from start to end and vice versa.
I would like to only affect the placement of commas in a column list, without applying other formatting options. This would work similar to Ctrl-B, Ctrl-B to remove brackets or Ctrl-B, C to insert semicolons, in that no other formatting would take place.
There are times I have a rather well-formatted script but it has been written with commas at the start of the line and I prefer them at the end. A new shortcut would toggle placing commas at the start or end of the line without affecting other formatting within the script.
5 votes -
script insert as
Today’s mail from https://sqlquantumleap.com/2019/05/09/maximum-number-of-rows-for-the-table-value-constructor/
Shows as way around the 1000 rows limitation on the VALUES ()… statement.Please enhance SQL Prompts “Script as Insert” feature to use this method.
Currently SQL Prompt is scripting it like this, when the results window has more than 1000 rows:
CREATE TABLE #temptable( [id_user] int, [RowCnt] int, [mt] datetime)
INSERT INTO #temptable
VALUES
( 372, 2,N'2012-09-01T00:00:00')
INSERT INTO #temptable
VALUES
( 196, 2,N'2012-09-01T00:00:00')
INSERT INTO #temptable
VALUES
( 210, 2,N'2012-09-01T00:00:00')
…It can be done like this:
CREATE TABLE #temptable( [iduser] int, [RowCnt] int, [mt] datetime)
INSERT INTO #temptable
select *
from(
values…5 votes -
format Window functions
SQL Prompt fails badly in formatting window functions. As these are present at least since SQL 2014, SQL Prompt should be able to interpret them and format them accordingly.
Example:
I would format the LAG() function as follows:
SELECT
myColumn AS realColumn
,LAG(myColumn, 1, 0)
OVER (
PARTITION BY someColumn
ORDER BY anotherColumn) AS calculatedColumnTry this with SQL Prompt - it's result is not very nice...
5 votes
- Don't see your idea?