230 results found
-
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
-
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 -
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 -
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 -
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 -
Formatting Profiles: add ability to use spaces for indentation
Indentation using tabs highly dependent on the settings tab size
1 vote -
1 vote
- Don't see your idea?