674 results found
-
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 -
Follow the Visual Studio Theme
I'm running a dark theme in visual studio. When the suggestions pop up they are very bright.
2 votes -
Script as Insert - Floats end up with innacurate data precision
After running a select on a table with a float(53) column, "Script as INSERT" from the right click menu on the results will script an insert with float(8) as the data type instead of float(53), presumably from the length of the column being recorded as 8 bytes when the float(n) is defined with n being bits.
Minor thing, but ended up causing issues with an equal statement since the floats had different precision when comparing to the original table.
1 vote -
I would like to be able to re-name a tab without actually saving it off as a sql file.
I would like to rename tabs without having to save them as a .sql file to the filesystem. I run with alot of tabs all the time and it gets very difficult if you don't name them to find a tab that has floated into the dreaded drop down arrow. Once its there I have to walk through the whole contents of the drop down list of query windows to find the one I want. With a simple rename of the tab that could be managed by the solution file. I would be able to label them and track them…
4 votes -
Finding tabs with the same code
Hi, the possibility to sort/show tabs with the same code. Then you can delete history if you have more than one tab with the same code. This will make history smaller and faster.
7 votes -
Tab History - Option to Open Multiple Tabs at Once
I use Tab History quite a bit, and I often find myself seeing 2 or more tabs that have the search criteria I'm after. Rather than just being able to click one tab to open it, it'd be nice to be able to select multiple tabs from the history (some or all of the result list). The amount I use it daily and the amount I need to open 2 or more tabs from a search this sort of functionality would save me the repetitive task of performing the same search over and over to get each tab open that…
12 votes -
Dark mode support
Dark mode support across all red gate tools.
9 votes -
Custom Aliases - Ability to Alphabetize by table name
Custom Aliases - Ability to Alphabetize by table name
4 votes -
Add support for LEAST and GREATEST
Please add support for the new SQL functions LEAST and GREATEST. Currently only available on Azure DB.
Information (can't find official Microsoft documentation): https://www.linkedin.com/feed/update/urn:li:activity:6737816854498291712/3 votes
- Don't see your idea?