270 results found
-
Toggle Comments
New option to Toggle commenting/uncommenting on the current line selections as most other editors have. Map to CONTROL-/ by default to match the commenting behavior of other editors.
Why SSMS does not have this baked in is f'in ponderous.
7 votes -
When a single quote is entered, add a trailing quote. And prefix leading single-quote with a N if field is unicode. Move insertion point
When a single quote is entered, add a trailing quote and prefix the leading quote with an N if equality with a Unicode value can be inferred. Move insertion point between the quotes.
7 votes -
Wrap words in IN clause
You can opt to have SELECT, GROUP BY, UPDATE, and other clauses stack their parameters. I think the IN clause should also have this capability.
6 votes -
Easy goto definition and graphical position of errors and search
Similar to power tools for visual studio 2010: Pressing Ctrl + Click to go to the definition of the element. Also implement the sidebar where you graphically visualize the position of the matching elements and code errors.
6 votes -
where used: From a view or sp or function get a list where you have used this
Sometimes you want to find all the places where you have used a certain view/sp/function because you like to change something in that part. Now its hard to find
6 votes -
Do Api command lines
To do Api command lines to execute the rules of the SQL Complete in a batch process. Also provide Api command lines give the possibility to create a javascript process to run a task each 2 hours (for example) in the repository of the sp's (for instance). If there is an error an e-mail will be sent to responsible of that sp
6 votes -
Force capital word
There are some identifiers and variables we'd like to force with CAPTITALS regardless of the formatting rules.
Similar to the "General > Available prefixes:", could we have a "Force word formatting" option where we can enter these special word types? ie. TranSid ==> TRANSID
6 votes -
column alias
I would like an option for column aliases. I would like to choose between = or AS for the "Alias sign".
The formatting should be done based on this "alias sign" and also be aligned by the alias sign.I prefer the = sign , but formatting doesn't seem to accept that as an alias now.
Example before formatting:
SELECT colA as [Column A], columnB as [ColumnLonger B]
FROM Table_1 tFormatting when "=" is used as "Alias sign";
SELECT [Column A] = t.colA
,[ColumnLonger B] = t.columnB
FROM Table_1 tFormatting when "AS" is used as "Alias sign":
SELECT…
6 votes -
Add an option to show/hide or find columns in the Results pane
It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.
6 votes -
DB (Catalog) filter
Similar to DB Object filter would like Catalogue / DB filter.
We used shared infrastructure so there heaps of DB / Catalogs to scroll through when are only working on 1 or 2.
6 votes -
Add procedure name as comment when using "Convert Exec to Script"
When using the Convert Exec to Script feature, it would be helpful to also include the stored procedure name at the very top to provide context to show from where the script was generated. see below. the bottom is what would show after Conver Exec to Script is completed.
exec uspMyProc
/* exec uspMyProc */
select *
from myTable6 votes -
Global Refactor (rename) tables/views/procs in dependent views/procs
SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.
For instance:
CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
GOCREATE VIEW dbo.vwTest
AS
SELECT * FROM dbo.Test
GOCREATE PROC dbo.spUpdateTest
(
@a int,
@b int
)
as
UPDATE dbo.Test
SET b = @b
WHERE a = @a
GOOn a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is…
6 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 -
Support formatting of ORDER BY clause within OVER clause
currently if I format the following code
select
row_number() over (order by cl.f1
-------, cl.f2
-------)
- 1 as f2
,cl.f3
,cl.f4
from #clients clI get this output
select row_number() over (order by cl.f1
-------, cl.f2
-------)
------ - 1 as f2
,cl.f3
,cl.f4
from #clients clbut the desired output is
select row_number() over (order by cl.f1
---------------------------------------------,cl.f2
---------------------------------)
------ - 1 as f2
-------,cl.f3
-------,cl.f4
from #clients cl5 votes -
Insert missing square brackets when formatting selection or whole script.
We have a policy of always putting square brackets around identifiers in SQL Scripts. When using SQL Complete we have the option turned on to always use square brackets and this works fine when scripting brackets are inserted for us just fine. However when we open a legacy script and format the document, missing square brackets are not inserted so we have to manually go through the script to add them.
If Always On is selected for square brackets then I press Ctrl+K Ctrl+D to format the document I would like to have missing square brackets inserted, that is all…
5 votes -
Scrollbar highlighting
When you select something in the SQL code and it selects all the other instances of it - e.g. a variable name, can you place coloured markers in the scroll bar of all the selected items, also for when you do a find as well. This is really useful feature in visual studio.
5 votes -
5 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 -
Create a variable table based on a available table in the schema
DECLARE @table varchar(100)
SET @table = 'claims'DECLARE @noScale varchar(255)
SET @noScale = 'INT,TINYINT,BIGINT,MONEY,SMALLMONEY'
SET @noScale=@noScale+',BIT,SMALLDATETIME,DATETIME' --Need for SQL2000
SELECT colName = ',' +
CASE
WHEN C.CHARACTERMAXIMUMLENGTH IS NOT NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE) + '(' + CAST(C.CHARACTERMAXIMUMLENGTH AS varchar(10)) + ')'
WHEN C.NUMERICSCALE IS NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.CHARACTERMAXIMUMLENGTH IS NULL AND CHARINDEX(C.DATATYPE, @noScale) > 0
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.NUMERICPRECISION > 0 AND CHARINDEX(C.DATATYPE, @noScale) = 0
THEN C.COLUMNNAME…4 votes -
multiple row tab
Provide for MULTIPLE TAB ROWS like TabsStudio has. This way there's no need for the file menu drop-down list, no need to manually pin tabs, the tabs keep stable order.
Thanks
4 votes
- Don't see your idea?