663 results found
-
Fix the confusing multiple usage of your company name
You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.
We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.
4 votes -
Separate ALIAS Alignment - table vs. column
Aligning based on column-alias makes for much better readability. When turned OFF, because some long-named table's alias pushes the TABLE-alias way to the right, all other table aliases follow it...into the NON-VISIBLE area (when using multiple vertical tabs).
Please SEPARATE these into TWO options:
. Align Column Aliases - on/off
. Align Table Aliases - on/offTHERE IS A BUG TO FIX HERE TOO: If a UDF is bounded by "--SQL Prompt formatting off/on" the TABLE ALIAS position REMAINS as if the UDF's alias was in it's SQL Prompt position, NOT where the excluded code has it! NASTY.
You could…
5 votes -
Stop OPENJSON after CROSS APPLY from showing up on new line
I have included a Sample SQL script. This script shows the desired formatting. I can't find any way to prevent the OPENJSON from being sent to a new line. For example:
SELECT *
FROM OPENJSON(@JSON, '$.Doc') AS OJ
CROSS APPLY OPENJSON(OJ.Value)
WITH (ID int) AS CAOJbecomes
SELECT *
FROM OPENJSON(@JSON, '$.Doc') AS OJ
CROSS APPLY
OPENJSON(OJ.Value)
WITH ( ID INT ) AS CAOJ2 votes -
drill down drill up from object display
In SQL Prompt, in the pop-up display for an object, allow drill down from an object reference in the popped-up display.
In the new feature showing dependencies, implement drill down (from the "uses" section) and drill up (from the "used by" section)
1 vote -
Draw line from begin to end of different colors
It would be nice to have colored lines that visually enhance the start / end of a while / if statement
4 votes -
Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE
Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE
1 vote -
Insert Snippet on New Query
Automatically insert a snippet as soon as you start a New Query in SSMS. I want all my developers to always start every script with a comment block with their username, date and a description of what the script is supposed to do. A shared snippet is already handy for this, but adding this could make it easier to build that habit for new team members.
2 votes -
Use formatter to create table of contents
It would be great to be able to use the formatter to create an automated table of contents based on some recognized commented pattern. For example, I could begin each section of code with:
--******
-- Title of section
--******Then after using the formatter it would see the commented section and add the line number for each section in the beginning of the script. I imagine something similar to MS Word's auto generated table of contents.
1 vote -
F12 to Create Table Script
F12 to Script views and stored procedures as ALTER is one of my favorite features. I would love it if F12 when I am on a table generates a CREATE TABLE script for that table.
2 votes -
Support for MS Dataverse / CDS
Add support so SQL Prompt will work in SSMS when connected to MS Dataverse / CDS (Common Data Service - Dynamics really).
Right now, it fails since the (meta)data exposed probably isn't quite as complete as on a "full-scale" SQL Server database
4 votes -
"Insert Semicolons" feature should add Semicolon after "BEGIN"
When using a BEGIN/END block, the "Insert Semicolons" feature adds a semicolon after "END" command, but not after the "BEGIN" command.
One reason why this should be done, is the use of the THROW statement, which requires the previous statement to be terminated with a semicolon.
Technically it is still runnable code, but, SSMS (as of version 18.8) sees it as a syntax error (see screenshot).
I don't know which is the appropriate fix...waiting for SSMS to fix the syntax error it shows (but I doubt they will since the non-use of semicolons is deprecated), or if it's appropriate for…
3 votes -
Find invalid objects in multiple databases
Please could you add an option to check for invalid objects in multiple databases and to be able to export the results in either a single file or 1 per database. It's a real pain doing 1 at a time and manually selecting the results to do a copy/paste.
4 votes -
Copy selected the column headers
After running a select statement, I want to be able to copy selected column headers without copying any data.
2 votes -
Quick Edit For Table Row Data In Query Result Grid
Scenario:
If I run any select query where filed1=value1 etc, and it shows one or more rows in the grid below.
Now I identify a required change and want to update that column value in a particular row.Current Process:
One option is to write an update query and change the column value.The second option is to right-click on the table and go to edit but again it only shows a limited number of rows at a time.
Requirement:
Option1: Allow right click on result grid and give the option to script the selected row/columns(s) as edit query.Option2:…
6 votes -
Do not auto complete literal strings
Currently SQL Prompt displays suggestions for auto-completing literal strings. These are never valid suggestions so can this be turned off (or at least have an option to turn this off)?
3 votes -
simple tabs (brent ozar)
https://www.brentozar.com/archive/2011/06/fixing-sql-server-management-studios-tab-text/
Brent Ozar wrote this tip back in 2011 and I cant believe i've been struggling with the horrible SSMS tabs every day for my whole career. would be great if SQL prompt has a button to change these settings for you or defaults these options when you install it.
the main reason being that they are buried away and if I wasnt aware of them then i'm sure many others aren't.
at the end of every day i have about 10 tabs open and i just close the whole lot because it's too hard and to go through them…
4 votes -
Tie the SQL prompt Scripting to SSMS scripting
IN SSMS there is an entire list of scripting options (turn off/on collation, extended properties, etc). Can SQL Prompt read those options and format the scripts it generates based on those settings?
1 vote -
"Script as INSERT" should refer to current table instead of a temp table
"Script as INSERT" creates an INSERT script with a tempt table, but instead it should script the current used table.
In that way you can easily write scripts to synchronize your data between different environments.
Thank you2 votes -
Suggest data truncation
Consider I've got a variable of varchar(35)
I perform an update on a column of varchar(10), it should suggest that there will be a truncation
2 votes -
Have Formal SQL Actions be included in the formatting style file.
Have Formal SQL Actions be included in the formatting style file. This way when a team shared a standard we do not have to share the file and screen shots of the Options menu to manually sync to maintain team consistency on code checkin.
2 votes
- Don't see your idea?