278 results found
-
Alias comprise of the first two letters of table name
Would it be possible to add an option allowing for the alias to comprise of the first two letters of the table name rather than the first, for example:
dbo.position po
dbo.product pr6 votes -
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 -
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
-
Fully qualified server reference
When performing a query like "Select * from Servername.schema.table"
where servername is the current server connected to, table hints are not available.
3 votes -
Ident guide lines
Visualize the ident guide lines in the document.
4 votes -
1 vote
-
Shortcut for partial selection
I'll be very glad if I could select a partial script in smart way and then run it with CTRL + SHIFT + E shortcut. The separator should be 2 blank lines, one at the top and one at the bottom of the script, and yes, I'm a shortcut addict. thanks a lot guys!
4 votes -
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 SSMS 2016
Support SSMS 2016 CTP
33 votes -
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’. -
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 -
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 -
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.
-
Add shortcut ctrl + k + d like Visual Studio
Add shortcut ctrl + k + d like Visual Studio for format document
9 votesSQL Complete v2.0 is on site!
- Don't see your idea?