230 results found
-
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 -
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’. -
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 -
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 -
Add extended properties for columns in quick info window for table
When navigating the mouse cursor to a table, display extended properties in the quick info window.
3 votes -
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 -
JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion
When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case3 votesThis can be achieved as follows:
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 ‘Tab’ option.
4. Click ‘OK’. -
Support formatting for @tbl_Table
Please add support for formatting table variable like other table similar format:
Declare @tbl_MyTable Table (
Id int,
Code nvarchar(50)
)1 vote -
1 vote
-
When formatting document or selection, leave cursor on same line on screen
When formatting a document or selection, the line with the cursor is moved as far down on the screen as possible. I would like it to stay on the position on the screen.
As it is now, I have to "search" for the cursor every time I have formatted and often I will have to scroll, since I will typically want to see the code below the cursor.
9 votes
- Don't see your idea?