275 results found
-
Sub condition formatting
Example of what you can get currently:
AND
(
old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);Example of what I'd like to do:
AND
(
----old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);4 votesThis can be setup as follows https://s8.postimg.cc/cqteckgid/sub_condition_formatting.png
-
1 vote
-
Fix erroneous formatting error when formatting DBCC show statistics
When "Format Selection" operates on the following T-SQL code an error is generated.
DBCC SHOWSTATISTICS(N'dbo.charge', _WASys000000060DAF0CB0)
WITH DENSITY_VECTOR;The error:
- C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (22,12): 'Identifier' expected
- C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (20,13): ''as'' expected
1 vote -
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 -
Should have provision to configure Query Alignment
Should have provision to configure Query Format
like (Each column to be placed in separate Line,
Join condition in single Line,
etc.)
or
Indenting is missing in formating1 vote -
intellisnese for temp tables
I was ready to buy but intellisnese on temp tables is a must
1 vote -
cte
It looks like the execute current statement command can't deal with CTEs which is a bit annoying. Overall this is great though, makes using SSMS much better.
1 vote -
I can't give a custom format to a clausule UNION
I can't give a custom format to a clausule UNION
1 voteThis can be setup in the ‘UNION’/EXCEPT/INTERSECT’ section 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. -
Add functionality to refresh the connection from ssms, when it is lost or kill i must open a new instance of ssms to get functionality back
Add functionality to refresh the connection from ssms, when it is lost or killed by my dba i must open a new instance of ssms to get functionality back
1 voteIn order to resolve this issue, please perform the following:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘General’ branch.
3. Unselect the ‘Enable SQL Complete’ option.
4. Click ‘OK’.
5. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
6. Navigate to the ‘General’ branch.
7. Select the ‘Enable SQL Complete’ option.
8. Click ‘OK’. -
Support SSMS 2016
Support SSMS 2016 CTP
33 votes -
Suggest object by capital letter abbreviation. Similar to ReSharper
When typing in a statement. For example:
SELECT *
FROM MyTableInstead of having to type in MyTable. I would just like to enter
SELECT *
FROM MTAt which point the suggestion box would identify the table MyTable based on it's initial capital letter at the beginning of each word.
Similar to the feature in ReSharper:
https://www.jetbrains.com/resharper/webhelp80/Navigation_and_Search__CamelHumps.html
0 votesPlease perform the following:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
3. Select the ‘Camel Case’ option.
4. Click ‘OK’. -
sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query (or vice versa), taking into account t
Sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query, taking into account the column aliases. Thus
INSERT INTO table
(columnA, columnB, columnC)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2becomes
INSERT INTO table
(columnB, columnC, columnA)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2With a few columns it's no big deal to do it manually but with 20 columns it is.
Displaying a hint if columns are missing is also welcome.1 vote -
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
-
Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function
When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.
E.g. -
SELECT * FROM Users u
CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif3 votes -
Declare Parameter in SP is not showing in List of Variables
When we Create some SP with Parameters and when we are using those parameter in SP Coding then Those parameter name is not showing in List of Variables..
Kindly solve this bug in new release...
1 vote -
Provide an option to insert the 'AS' clause before aliases
I want to be able to insert the 'AS' clause before all aliases. Currently, SQL Complete does not insert the 'AS' clause.
1 voteThe ‘Automatically generate AS clause’ option is available in the ‘Alias’ section of the ‘Options’ window that can be invoked by selecting ‘SQL Complete → Options’ from the main menu.
-
mark opening or closing brackets when another is selected
sql complete doesn't mark openning brackets when closing is selected etc. it's working in SSMS but, when i install sql complete it doesnt'.
6 votes -
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or to browse to the object.
1 vote -
Add type into into Tooltip for table column
It would be very usefull if tooltip (OnMauseOver) for column name in select would also provide info about column type, for example
[table].[column](column) => [table].[column](column, int)4 votes -
Support temp tables in Intellisense
Make intellisense to cover the temporary table for example "#rs" ,"##table"
3 votes
- Don't see your idea?