272 results found
-
Highlight Unused Variables
Declare @var1 INT, @var2 INT
SELECT @var1 = 1, @var2 = 2
SELECT @var1 [@var1]
-- @var2 should be highlighted in the declaration since its assigned value is never used.128 votes -
Ability to define default values for stored procedure parameters expanded by pressing Tab
When you type out "execute SPROCname" and then press Tab, SQL Complete very nicely builds out the list of parameters with commented out datatypes. Really like that. The one thing that would take this from being good to great would be if it filled in any default values from the procedure. Now that would be fantastic!
5 votes -
Add option to make snippits keywords only look to the left of the cursor of the current word.
I often wish to trigger the "select * from" snippit by doing the following:'
1) Drag table from ObjectExplorer to a new line (or copy/paste to new line)
2) Press "Home" to get to beginning of line
3) Press "ssf" then "tab" to fire the triggerThe problem is that because the tablename is connected to the snippit, the snippit doesn't fire, and i have to then add a space, go back one spot, then hit tab.
The snippits also seem to require that all code on the rest of the page be correct. Often I have an open query…
1 vote -
code preview when hovering a tab or session in the "Documents Sessions" window
Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.
3 votes -
indent logical operator
In a WHERE clause, there is an option to wrap before a logical operator, but then the operator is aligned with the WHERE keyword. I'd like an option to indent logical operators in the WHERE clause, so it's clear that they are under it.
0 votes -
Add option to align columns in WHERE clause
I'd like to align the columns in the where clause like this:
WHERE
---------------a.AddressLine1 IS NOT NULL
--------AND a.AddressLine2 IS NOT NULLI'd like the two "a." to align.
1 vote -
fixed length table alias
create an alias with a fixed length this will make the cut and past of a block much easier
1 vote -
Add stack option for wrap condition in FROM and JOIN clauses
I'd really like the ability to have a stack option for the wrap condition in the FROM > JOIN options. What I mean is, I want to align conditions by the column name like this:
JOIN Person.Address AS a
ON e.ModifiedDate = a.ModifiedDate
AND e.rowguid = a.rowguidI'd like the two "e." to align. Simply inserting a tab after ON and after AND will achieve this.
1 vote -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
3 votes -
When pressing "Enter" at the end of a line, the indentation of the next line should be same as the previous line
For example:
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
ENDInstead of
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
END1 vote -
Text editor improvement: Text column select enhancements
When I am in Visual Studio and I hold down Alt and select a range of text, I can start typing and it will type into all rows. I use this frequently to type something that needs to be typed across several lines. In SQL Server Management Studio, the highlight process works, but as soon as you start typing, it only types in the first row that is selected.
I would really like to see the input behavior from Visual Studio mimicked in SSMS.
1 vote -
Ability to insert frequently used templates without need to modify them
Let's assume, a user have about 10 most frequently used templates that do not need to be modified after they have been inserted unlike snippets.
0 votes -
Put variables in VALUES clause when expanding INSERT statement
You type in an insert statement. " Insert into dbo.Party" and then press tab. The below code is generated
INSERT INTO Party
(
PartyTypeId,
TenantId
)
VALUES
(
0 /* PartyTypeId - INT NOT NULL /,
0 / TenantId - BIGINT */
)Because most of the inserts, updates etc are mostly used inside stored procedures, and the values come from variables, I would like it to show :
INSERT INTO Party
(
PartyTypeId,
TenantId
)
VALUES
(
@PartyId /* INT NOT NULL /,
@TenantId / BIGINT */
)An updated statement will do the following snippet :
UPDATE Party…
5 votes -
Format: stack list table view format for JOINs
You already provide an option to align column aliases in a select statement by a table view option in the stack list.
how about alignment for tables aliases in a JOIN statement
e.g.
SELECT *
FROM dbo.table1 t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table t ON (t.c1 = tx2.c2)/*****************************
** To This
** using _ to simulate spaces
/*****************************/SELECT *
FROM
____dbo.table1 _t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table __t _ON (t.c1 = tx2.c2)7 votes -
Ability to configure JOIN suggerstions for tables with no relations
Automatically propose join tables when JOIN instruction is typed.
Proposal should not be baseed on existing tables relationships since most ERP out there do not have such relationships within the database.What I would like is that the user can configure all joins he knows for each tables and when the user types a SELECT instruction with JOIN that SQL Complete propose the list of all preconfigured joins for the tables already part of the SELECT.
Ex:
SELECT fields
FROM Table1
INNER JOIN Table2 ON Table1Key=Table2.Key
INNER JOIN <here SQL Complete> would propose all preconfigured joins for Table1 AND Table27 votes -
disable / autoexclude colums [v].IDENTITYCOL, [v].$IDENTITY from select
Exclude columns [v].IDENTITYCOL, [v].$IDENTITY from select when checking the table checkbox on the suggestion popup window
example:
SELECT [v].id, [v].name, [v].IDENTITYCOL, [v].$IDENTITY FROM table [v]3 votes -
add a "edit data from query"
Add a "edit data from query", on the left click, in the query editor, to open the same module as when "Edit top 200 rows" in the table list is selected.
1 vote -
Include underscore in CamelCase interpolation
In our schema, we have the unfortunate convention (if you can call it that...) of including underscores in many table and sproc names. For instance, a report sproc might be named ReportSalesByChannel. It would be awesome if the CamelCase interpretation either completely ignored the underscores in the name while providing the suggestions (so typing rsbc would suggest the above named report), or make it so the _ is one of the interpreted characters, which would allow rsbc to again suggest the above sproc. Right now any stored procedure with an underscore cannot be quickly suggested by any abbreviation…
12 votes -
Show list of procedures on typing procedure name even with no EXEC
Show the list of available procedures when start typing a procedure name, for example:
sp_proc1
4 votes -
Host SQL Snippets on some sharing site
Provide a facility for us to easily access our snippets from anywhere and share with the community.The Community should be able to upload or browse for interesting and useful snippets.
Possibly allow to search for snippets online. much like how VS2010+ allows to find extensions.
2 votes
- Don't see your idea?