14 results found
-
Code formatting for Merge Into "Values"
Merge doesn't have formatting for source table formed from values.
MERGE INTO [TargetTable] AS T USING (
VALUES (@UserId, @InternalId)) AS S
([UserId], [InternalId])
ON T.[UserId] = S.[UserId]
WHEN MATCHED ...5 votes -
Intellisense for table definition should use INFORMATION_SCHEMA data.
It seems the current implementation parses a CREATE TABLE statement and only shows the columns defined there when you hover over a table name. Columns added later via ALTER TABLE statements do not show up. The intellisense list should be built by querying the CURRENT table structure via INFORMATION_SCHEMA.COLUMNS in order to show all columns.
3 votesPlease check that you have selected the ‘Automatically refresh suggestions cache’ and ‘Detect changes on a server before refreshing suggestions cache’ options in the ‘Text Editor → Code Completion → General’ section of the ‘Options’ dialog box that can be opened by selecting ‘Tools → Options’ from the main menu.
Please also check that the altered object belongs to the database selected in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.
-
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 -
table function hint shows wrong parameters
When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.
3 votes -
Execution History not saving data
I have a problem with execution history, recently it stopped behaving correctly. So I daily use SSMS and connect to 2 local instances and several other azure instances. When I open the execution history I notices sometimes that I do not have a log for anything for the past 2 days, for example today is 9th of July, and "Execution History" has records for 7th of July.. 8th and 9th are not there.
Also it is not recording all executions for all servers, so it might record only 1 for a server and several for another. I am not sure…
3 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 -
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’. -
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 -
1 vote
-
Built-in DataType Case option is being ignored
In SQLComplete 5.5.159, the Built-in DataType Case set to lower, but all types are automatically converted to upper case
1 voteThis can be setup as follows:
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.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Navigate to the ‘Text Case’ node and select the options you need. -
Support for multiple SSMS instances
When running two or more SSMS instances there is an error that pops up pretty often saying: "Access to the path 'C:\Users\FFlintstone\AppData\Roaming\Devart\dbForge SQL Complete\docsessions-journal.db' is denied."
1 voteThis issue is fixed in dbForge SQL Complete, v5.6.169 https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
checking update failed
The checking update menu in sql complete may point to a HTTP url and currently devart.com is only available via HTTPS protocal. It let the update checking 100% failed with network error message: cannot connect to remote server.
1 vote -
SQL XML fucntion value is changed to Value (uppercase V) when formatting a document. This is not valid SQL
Formatting document should not change value to Value in an XML SQL query. Value is not a valid function
1 vote -
Meaningful parameter names for system functions
Example: suggestion for CAHRINDEX function should look like (expressionToFind , expressionToSearch) instead of (expression1, expression2)
1 vote
- Don't see your idea?