267 results found
-
Formatting for Synapse
I have started using Serverless SQL Pool within SSMS. I have seen and voted for a post for Intellisense, but it would be good to be able to format a query too. For example the below query:
SELECT cast(r.filepath(1) as varchar(100)) as [$FileName], ISNULL(SysRowId,0) AS _SysRowId, ISNULL(LSN,'') AS LSN, ISNULL(LastProcessedChangeDateTime,'1900-01-01') AS LastProcessedChangeDateTime, ISNULL(DataLakeModifiedDateTime,'1900-01-01') AS DataLakeModifiedDateTime, ISNULL(RECID,0) AS RECID, Language, Status, Stage, ISNULL(DataAreaId,'') AS DataAreaId, ISNULL(PARTITION,0) AS PARTITION, ISNULL(RECVERSION,0) AS RECVERSION
FROM OPENROWSET(BULK 'Tables/StgTable/*.csv'
,FORMAT = 'CSV', PARSERVERSION = '2.0', DATASOURCE ='wsds', ROWSETOPTIONS = '{"READOPTIONS":["ALLOWINCONSISTENTREADS"] }'
)
WITH (SysRowId…6 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
5 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 -
New Query Template
It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc
4 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 -
Separate (one-line) format for simple "when then else end" statement
It would be nice to be able to specify a separate format for simple case statements with only one 'when' and possibly an 'else' clause. These can typically easily fit in one line, while complicated case statements benefit from taking up the additional lines to improve readability.
declare @profit float = 10
/* Simple case statement can fit on one line */
select case when @Profit > 0 then 'Great' else 'Not so great' end/* Complex case statement requires multiples lines */
select case
when @Profit > 10000 then 'Nice!'
when @Profit > 0 then 'OK'
else 'You''re fired!'…4 votes
- Don't see your idea?