157 results found
-
Empty line management
There should be a global empty line management structure for formatting. It would be nice to see:
- Add empty line before/after keyword - Remove empty lines - Add empty line between statements
17 votes -
Format SELECT columns. Alias on left, object on right separated by aligned " = ".
Format SELECT columns. Alias on left object on right separated by aligned " = ".
e.g.
SELECT
ThisIsMyFirstCol = a.Col1
, SecondCol = a.Col2
, AndTheThrid = a.Col3
, ForthCol = b.Col1
, FithCol = CASE WHEN a.col1 = b.col2 THEN 'A'
WHEN a.col2 = b.col3 THEN 'B' ENDFROM dbo.tableA AS a INNER JOIN dbo.tableB AS b ON a.Col1 = b.Col1
12 votes -
Automatically generate DROP <OBJECT TYPE> IF EXISTS statement
In a SQL script, I create several schemas, tables, and procedures. I'd like to have the ability to right-click an object name (in the editor), and select something like "Generate DROP IF EXIST".
The tool would understand the object type and automatically add the following to the top of the file:
DROP PROCEDURE IF EXISTS <SchemaName1.ProcName1>
DROP PROCEDURE IF EXISTS <SchemaName2.ProcName2>
DROP TABLE IF EXISTS <SchemaName1.TableName1>
DROP TABLE IF EXISTS <SchemaName2.TableName2>
GO
DROP SCHEMA IF EXISTS <SchemaName1>
DROP SCHEMA IF EXISTS <SchemaName2>13 votes -
Refactor - Qualify Objects
Offer refactor option that fully qualifies object names with schema. I know the option is there to do this when typing, ensuring aliased/qualified names. However, one feature in SQL Prompt from RG that is pretty amazing is the option to "refactor-qualify", and it will parse all the object schema names and ensure your proc/table/view/etc calls have the schema name in front of them. This is considered a good practice, but doing manually is very time intensive.
16 votes -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes -
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
3 votes -
Support dynamic formatting using @SQLComplete tag to override a setting
There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.
For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.
If you could add a comment before the query
--@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…4 votes -
Virtual Folders for Database Objects In SSMS
The ability to add folders in SSMS for database objects. I understand these folders would only be virtual.
I know of one addin that has this feature. www.sqltreeo.com
43 votes -
Remove square brackets
Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.
I want a feature to remove all square brackets.
I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.
Jake
73 votes -
in visual studio, right click on table to select top 1000 rows
in the ssms object explorer, many of us regularly right click on tables to select top 1000 rows, which opens a new query window with an editable query script. visual studio's sql object explorer has no such functionality besides view data which forces you into a designer-based edit mode.
11 votes -
Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause
For example, let's assume this is the output from a query:
id name role
1 Torn ADMIN
2 John CLERK
3 Adam SUPERI would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.
In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
name = 'Adam' and role = 'SUPER'16 votes -
Notifications pane
Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.
1 vote -
Display a single row of data in column format
As per Oracle SQL Developer ability to select a row of data and have it displayed in a column. Makes viewing a large row of data a lot easier.
1 vote -
1 vote
-
Popup 'select top 100'
I often find when writing queries in the Sql editor that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
1 voteAdminDevart (_, Devart) respondedYou could use the snippets functionality of dbForge SQL Complete.
The snippet can be as follows:
SELECT TOP $count$ *
FROM $schema$.$table_name$ -
De-couple execute-current-statement functionality from code completion.
I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.
3 votes -
Execute current statement with variables
When running a query via "Execute Current Statement", it doesn't run if there are variables referenced. Instead you have to highlight the variable + query to get it to run. It would be nice if the variables were automatically included in the execution
1 vote -
2 votes
-
SQL Complete (or at least formatter) for Firebird?
Could you expand the SQL syntax to allow SQL code formatting for Firebird SQL?
1 vote -
1 vote
- Don't see your idea?