275 results found
-
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 -
Formatting Presets
Everyone has their own preferences for formatting, which is why I think the number of options you provide for the formatting is really impressive. I think, however, that people likely tend to fall in to camps when it comes to their preferred formatting, so it might be helpful to determine the common configurations of the formatter, and then provide a handful of presets for the user to try out (with a preview of how various queries would be formatted). They could then go through and find whichever preset most closely matches their style, and then tweak it from there. Should…
1 vote -
Filter formatting options based on selection
This would likely have to wait until the live preview is implemented http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1434717-a-handy-feature-would-be-to-show-a-live-preview-of
It would be awesome if there was a way with the live preview for the UI to indicate which options affected a given line. So, for instance, you click on one of the conditions in the WHERE clause, and it indicates that the 'New Line Before', 'Indent Clauses', and 'Word Wrap' options all contributed to how this line looks. That way if, for instance, the formatter is placing the 'AND' statement after the condition rather than before as you would prefer, the many options would be filtered…
1 vote -
Formatting Source Code (Ctrl K,D)
I like Formatting source code, but for some keywords it not work fine me and make me irritate. The Following are the suggestion regarding Auto Formatting of Code on K, D in SQL.
1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.
2. Ctrl + K,D does not format IF and UNION keyword. It should be like it is…1 vote> 1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.
You were using an old version of the product. Please upgrade dbForge SQL Complete to the latest version 4.0.55 where the issue is fixed: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
Please note that you can setup dbForge SQL Complete as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select a profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Select the ‘Text Case → Identifier Case’ branch.
6. Select one of the options.> 2. Ctrl + K,D does not format IF and UNION keyword.…
-
stacking indent when using "if else if"
when i want tu format if else if block i want to get someting like this :
if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
endBut best what i can do is this stacking indent behavior:
if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else
…if (1 = 1) begin set @avgweight = (select AVG(Weight) from Production.Product); end else if (1 =
1 vote
- Don't see your idea?