638 results found
-
Autocomplete WHERE clauses with variables
It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:
Assume Table1 with one column Column1.
DECLARE @Column1
SELECT *
FROM Table1 T
WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)2 votes -
move options settable under "SSMS > SQL Prompt > Options > Format > Style" page out of the Settings file and [back] into Style file
In version 7 the Style option FormatActionRemoveSquareBrackets was removed from the .sqlpromptstyle Style file into the .settings Settings file. I would like it moved back into the Style file, along with all other Style options settable under "SSMS > SQL Prompt > Options > Format > Style". See https://productsupport.red-gate.com/hc/en-us/requests/122489 for additional details.
2 votes -
Make a
Similar to visual studio code, it would be good to have a find and replace all occurrences by highlighting what you would like to replace. This would then give you the option to type in what you want to replace. I know Sql Server has a find and replace function, however I just really like this functionality and think it would be a great addition to SQL prompt
1 vote -
1 vote
-
16 votes
-
Add option to exclude placeholder or escape it.
I have text within a snippet which includes the string "$2a$". The snippet manager replaces this which is not what I want. I need the snippet to remain unchanged.
2 votes -
Dockable Summarize Script window that allows select/run of script blocks.
Summarize script is sort-of useful as a way to see script blocks easily, but it will be BRILLIANT if it was a dockable (not modal) window that you very quickly select the script blocks in the editor.
I often select parts of a script or subqueries to run - if Summarize Script automatically selected them for me it would be a huge productivity boost: 1-click selection + F5 = AWESOME!
42 votes -
EXEC sp without return (EXEC @Results = sp)
EXEC spwho2 without return (EXEC @Results = spwho2)
Give a warning when tsql or stored procedure has execute a stored procedure without a variable for an error to bubble up to.This is the proper way because ieven in a try catch the Exec sp_who2 won't give and error to stop the tsql from going on
3 votes -
Add rule for deprecated DATABASEPROPERTY
Add rule for deprecated DATABASEPROPERTY
3 votes -
Conditionally place ON keyword on new line if exceeds specified wrap margin
My default preference is to maintain the ON keyword without a new line. I would like to be able to CONDITIONALLY place the ON keyword on a new line if, and only if the ON keyword together with the associated ON condition exceed a configurable wrap threshold.
Example:
-- Yield this >>>>
SELECT *
FROM Person.Address
INNER JOIN Person.StateProvince
ON StateProvince.StateProvinceID=Address.StateProvinceID
-- >>>> instead ofSELECT *
FROM Person.Address
INNER JOIN Person.StateProvince ON StateProvince.StateProvinceID=Address.StateProvinceID
-- Assuming the JOIN clause exceeds the wrap length
-- <<<This is particularly useful if the "Place JOIN table on new line" is NOT selected…
3 votes -
Inconsistently Advised to Use Alias For CTE (ST010)
Simple statements do not flag this:
WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable)
SELECT a.TestColumn FROM CTE1 a
INNER JOIN CTE1 b ON a.TestColumn = b.TestColumn;However, more complex statements do:
WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable),
CTE2 AS (SELECT TestColumn FROM CTE1),
CTE3 AS (SELECT TestColumn FROM CTE2)
SELECT CTE3.TestColumn FROM CTE3
INNER JOIN CTE2 ON CTE3.TestColumn = CTE2.TestColumn;In the final select clause, both CTE2 and CTE3 are flagged with 'Use alias for all table sources' (ST010).
Seems a bit OTT to suggest references to CTEs are aliased? I accept that a CTE defines, in relational terms,…
4 votes -
Search Results in Grid Mode
Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.
19 votes -
Choose to have ALTER instead of CREATE scripts
When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.
99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.
14 votes -
IN clause - indent according to parenthesis rules according to the expression they are in
It would be nice if the IN clause were formatted like a logical function that returns a value so that it followed the options and rules for parentheses and were indented according to its place in the logical expression. (paying attention to the ANDs and ORs if present)
2 votes -
Offline TSQL code analysis and Standardization report..Where we can add custom rules regarding to company naming procedure
My Name is Waleed Abrar and my license number is. I am actively looking of Static TSQL Analysis and I was really happy with the SQL Prompt. I have done some analysis and implemented some test cases. It works really good working live and parallel to development . I want to ask if it’s possible to do an offline analysis and get a HTML or Excel report for a particular database about the TSQL code Quality inside the DB. For Example I can select the Database ‘XYZ’ and then click Analyze static code. It will give me a report back…
2 votes -
Code Analysis EI028 Incorrectly Identified When Adding Not Null Column With Explicitly Defined Default Value
Stop raising EI028 when adding columns using style:
ALTER TABLE dbo.MyTable
ADD TestColumnB CHAR(1) NOT NULL,
CONSTRAINT DFMyTableTestColumnB DEFAULT ('B')
FOR TestColumnB;2 votes -
Arithmetic expressions - format consistently with logical expressions
Arithmetical expressions and compound logical expressions all consist of operations and expressions with parentheses and orders of precedence. All of these should have the options for aligning operands, aligning parentheses, adding parentheses to make the default orders of precedence explicit. All expressions are subordinate to clauses so they should be indented under WHERE, ON, SELECT, WHEN.
1 vote -
Smart Rename to change case
sometimes I need to just change the casing of letters in a field name (e.g. a field has GUID and I want to make it Guid). smart rename does not allow me to change the name if the new name is exactly the same saying that a column with this name already exists.
so I change the name to GuidXXXX and then on the generated script remove the XXXX and the script runs just fine.
I think smart rename should not warn that the name exists if I am just changing casing of the name
8 votes -
Create CRUD
Create a Select/Update/Insert/Delete procedure by rightclick a table.
With option to select columns for each statement.
34 votes -
Create "declare table" snippets
I am in the process of converting many Stored Procedures to UDFs (for various reasons).
One thing that is irritating is that these SPs often use the SELECT x, y, z INTO #tempTable pattern.
Would that be possible for you to generate the equivalent DECLARE @tempTable TABLE ( x TYPE,y TYPE,z TYPE) statement?
That would have proven to be very helpful!
2 votes
- Don't see your idea?