663 results found
-
Include MERGE statement in smart rename
When one would like to smart rename a column, the smart rename function does not update a MERGE statement. Could this be added to the smart rename feature?
13 votes -
Option to include the schema when generating an alias.
I have tables that repeat in different schemas, for example Supplier.Location and Customer.Location. I'd really like auto-alias to include the schema when generating the alias. Supplier.Location should be SL and Customer.Location should be CL. Instead I end up with L and L2, which is not as clear.
Ideally, I'd prefer the schema characters to be lowercase and the table to be uppercase. Using sL and cL would make my query even more readable.
13 votes -
warn against data truncation
I would be nice if SQL-prompt could warn against posible data truncation.
Like assigning a int value to a tinyint field/variable or assigning a varchar(30) to a varchar(3).
I want it both at an global analysis (like find invalid objects) and in the current scrip edit (while modifying a trigger / procedure / function).13 votes -
More "power" to tabs
1) add a possibility to set custom colours to tabs
2) pin in/pin out tabs
3) automatically set colour for executing queries tabs
4) add possibility to pop-up windows when query execution finish13 votes -
Possibility to search for multiple keywords
It would be nice to search for multiple keywords in the Tab History. For example, I know I had a script to insert data from TableA to TableB, but I searching for TableA or TableB yields to much result (both are frequently use tables). Searching for "TableA, TableB" or "TableA*TableB" would be a good quality of life feature.
12 votes -
Tab History - Option to Open Multiple Tabs at Once
I use Tab History quite a bit, and I often find myself seeing 2 or more tabs that have the search criteria I'm after. Rather than just being able to click one tab to open it, it'd be nice to be able to select multiple tabs from the history (some or all of the result list). The amount I use it daily and the amount I need to open 2 or more tabs from a search this sort of functionality would save me the repetitive task of performing the same search over and over to get each tab open that…
12 votes -
Provide the option to create custom rules.
Open the Rules Engine API so that we can create our own organizational specific rules.
For example, I would like to be able to flag datetime, getdate(), getutcdate().
12 votes -
THEN expression on same line as keyword
Current formatting is:
CASE
WHEN 1 = 1 THEN
'Hello World'
ENDI need the option to put the expression on the same line:
CASE
WHEN 1 = 1 THEN 'Hello World'
END12 votes -
Warn before running code that might fire trigger
SQL Prompt gives me a warning when I execute a query or batch that would truncate a table or that includes an update or delete without where clause.
Is it possible to get a similar warning when I execute a query or batch that runs an insert, update, delete, or merge statement against a table or view that has a trigger? (ideally the warning would only fire if the trigger is not deactivated, and if it is for the correct operation)12 votes -
Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.
What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.
12 votes -
Smart Rename should include renaming a Schema
Self explanatory... Need to right-click a user-defined schema and be able to generate a script that effects the scema rename and code within all affected objects. Would be great to add a list of additional databases in which to look for candidate objects to change: triggers, SPs, UDFs...
12 votes -
Azure SQL Intellisense....please!
I do not see Intellisense for AZURE sql. Please, please, please. There's code formatting, but no actual intellisense like ssms.
11 votes -
Automatically add DROP TABLE IF EXISTS for #temp tables
It would be nice if SQL Prompt had a way to add in the code DROP TABLE IF EXISTS #table for temp tables. Ideally it would add the statement immediately before the table is created from a CREATE TABLE or SELECT INTO statement.
11 votes -
Top with parenthesis should be a formatting option
Changing
SELECT TOP 10...
to
SELECT TOP (10)... should be a formatting option.
11 votes -
Ability to format SQL text externally
It would be nice to have ability to format the documents automatically, have an API or command line command for that. For example to force format when check-in code.
11 votes -
Ability to generate SELECT test script from an UPDATE statement
When debugging an UPDATE statement, it would be handy if SQL Prompt could generate a test Select script that converts
UPDATE xxxxxx
SET SalesPeriod = dddddd,
SalesYear = yyyy,
CustomerCode = zzzzz
...into
SELECT dddddd as SalesPeriod,
yyyy as SalesYear,
zzzzz as CustomerCode
....Optionally, could include all columns involved in joins or WHERE clauses
11 votes -
Keyboard shortcut to comment/uncomment PRINT statements.
I'd like a feature with keyboard shurtcut to comment/uncomment the TSQL PRINT statements.
11 votes -
Customize Keyboard Shortcuts
It would be perfect if we could change the keyboard shortcuts, I like to use Ctrl+Enter shortcut to execute current statement (like Oracle SQL Dev) and I can't change the default Shift+F5 on SQL prompt.
11 votes -
Keyboard macros
Create ability to write keyboard macroses. For example I have following lines:
column1 as varchar(100),
column2 as int,
...
column117 as uniqueidentifier primary keyI want to get all column names. What I usually do, I am copying it to external editors that support macroses and record it on the first line with following actions:
holdctrl+right(cursor goes to the end of column name), holdshift+pressendbutton (highlights entire row),pressdel (to delete this text),press,(to add comma at the end),pressdown(to go to the next row),presshome (to return at the beginning of the second row)
Then I…11 votes -
LINQ Style SQL
What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).
The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like…
11 votes
- Don't see your idea?