280 results found
-
Option between stack or place on single line should be radio button
Option between stack or place on single line should be radio button instead of a check box.
that applies to multiple areas including:
select
common table expressions
from
group by
and order by2 votes -
Bug: subquery select keyword not indented
When option subquery> "line break after open brace" is not selected, the keyword select of the subquery would not be properly indented.
2 votesTry SQL Complete 4.5 beta!
-
Formatting: Stacked list - Minimum indent
Under "stacked list" group you should be able to specify a minimum indent value (tabs) for the "table view" layout.
2 votesThis can be setup in the ‘Text Options’ section that can be invoked by pressing down the ‘Show text options’ button on the toolbar of the ‘Edit Formatting Profile’ window.
To open the ‘Edit Formatting Profile’ window, please perform the following:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Edit Profile…’ button. -
Execute statements to cursor position
I would like to have option(keyboard hotkey) that can execute all statements which are above of cursor position including statement with current cursor position.
I would call this feature: "Execute query to cursor position"
I think its very helpful while debugging/creating stored procedures or sql queries
2 votes -
Format temporal tables with table view
Format the statements with table view
DECLARE
@tbl_VentasDetail TABLE (
Id int,
VentaDetailID int,
VentaID int,
EmpresaID int,
PuntoVentaID int,
ProductoID int,
VentaDetailLinea int,
VentaDetailConcepto nvarchar(50),
VentaDetailCantidad decimal(18, 2),
VentaDetailPrecio decimal(18, 2),
VentaDetailCosto decimal(18, 2),
VentaDetailBaseImpuesto decimal(18, 2),
VentaDetailDescuento decimal(5, 2),
VentaDetailImpuesto decimal(5, 2)
)2 votesThis could be achieved by changing the options for CREATE TABLE
-
Fix accidental error message popup acceptance
When intensely typing a query and SQL complete has an error in the middle of typing, the error popup window steals focus and if a key is pressed as part of the sql query that accepts the restart ssms button, ssms restarts losing the current work.
2 votes -
Suggest keywords by relevance
When suggesting keywords place more relevant to this context to the top of the list.
1 voteSQL Complete v2.0 is on site!
-
Import/Export options utility
it could be usefull an utility to import/export the options configured by the user.
1 voteIncluded into SQL Complete v2.50
-
Place comma before a parameter item
Place comma before a parameter item when you write a stored procedure or function
1 vote -
having also parameters listed in intellisense
SQL 2008 intellisense also show parameters, this software no (at least the free version); it would be nice to have it
1 vote -
1 vote
Version 3.0 is on the site
-
Include column names after the where clause. If alias is present using alias.column name format
When using WHERE clause in select or update query, columns name don't appear even if alias.ColumnName is used e.g.
SELECT
*
FROM
Table t1
WHERE
t1.? (Columns should appear here)1 vote -
auto select the first suggestion
Auto select the first suggestion by default, and I don't need to click or select it, thanks.
1 voteSee comments
-
All keywords should formated
Sql Complete should format 'if' and 'begin' 'end' like
DECLARE @a as int
SET @a = 1
if (@a=1)
begin
print('a')
end1 voteThis functionality is already implemented in the product. If you have problems with it, please contact technical support.
-
Provide option to align column aliases
Currently, aliases are placed directly after the column name. Would like to be able to align them and see all aliases in the same column start position
SELECT
, FirstName + ' ' + LastName PurchasedBy
, BranchName BName
, DamageTotal Damage
, PurchasePrice - WBACValuation AdjAmount1 vote -
Few more features
- After where or any other keyword, add a space
- If there is a list of suggestions (ex. for a field name, user should be able to select the last item by the down arrow)
- When one bracket is put, complete the other bracket and bring the cursor point to the middle
The same suggestion as above for the Begin - End (Also the Begin isn't auto complete)
1 vote -
Declare indent
Allow option to not fancy indent declared variables, but just put a new line after declare, and have all variables just indented with a tab (normally).
1 vote -
Add 'Place view definition on new line' option
Make it ignore the DDL part and just format the actual view definition
ALTER VIEW v_xyz AS
SELECT
.. some complex queryGO
1 vote -
Add 'Place open brace on new line' option for WITH clause
WITH Dates
AS (SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dateswhere I am expecting it to look like this:
WITH Dates
AS (
SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dates1 vote -
More estetics, more light
A) connection identification
a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
a.2. allow a logo on right-bottom from local file or table.field of current connectionB) if I have mySAP's 18.000 objects....
b.1. allow completition ondemand on key (TAB) with rotation searching:
objs: tblarc1, tblarc2, ...
select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
(can rotate or use SHIFT+TAB to go back)
b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)…
1 vote
- Don't see your idea?