674 results found
-
Azure SQL Intellisense....please!
I do not see Intellisense for AZURE sql. Please, please, please. There's code formatting, but no actual intellisense like ssms.
12 votes -
ORDER BY 1 gives incorrect warning
The following gives the warning "ORDER BY clause with constants". In this statement, "1" is not a constant, but a reference to the 1st column.
SELECT TOP (10) Field1, Field2 FROM MyTable ORDER BY 1 DESC
1 vote -
SQL Prompt doesn't restore connections after restart when using Azure Active Directory - Integrated authentication
There is a bug in SQL Prompt . It doesn't restore connection after restart when using "Azure Active Directory - Integrated" authentication in SSMS 18+ or SSMS 19+.
Tab is opened as disconnected.
1 vote -
Script as Insert
With the Script as INSERT feature, give the option to just copy the CREATE TABLE and INSERT INTO statements to the clipboard.
I regularly create Temp Tables to store query results when working through a SPROC. (Generate a dataset, throw it in a temp table to use for later, drop it at the end of the SPROC. More efficient than doing one massive Select with Subqueries.) When you Script as INSERT, that's created in a new tab. I copy that code and go back to the original tab.
Would be convenient if I could copy straight to the clipboard and…
4 votes -
New Code Analysis Rule: Flag system named constraints
It is generally bad practice to use system named constraints and there should be a rule for flagging them when there is DDL code creating one.
3 votes -
Add the ability to specify a named formatting style using a comment block.
Add the ability to specify a named formatting style using a comment block.
Add functionality to specify, in a comment block, what formatting style should be used when formatting the current file. It could be a simple addition to the existing turn-on/off formatting comment.
Perhaps something like this:
--SQL Prompt Formatting On - Style = "My Style"The above would turn on formatting and specify what style to use.
This functionality would be helpful in many ways.
It is already convenient to have multiple formatting rules, this would keep the user from having to remember what rules apply to what…
6 votes -
Add SQL Prompt to the Mac / Linux version of Azure data studio
I see that Azure data studio support is on the roadmap, but cannot see any reference to the MacOS / Linux versions of Azure data studio?
Would be great to not have to boot up Windows to get to the awesome speed and power which SQL Prompt provides.132 votes -
Format on Save
Allow an option when saving / running a file that you format the sql to the format selected. Will make sure the whole team follow the standards and does not forget to run the formatter.
4 votes -
Script as Insert #tempTable to snippet/placeholder text
When using the Script as Insert, it generates the Create Table with the table name as
#temptable. If you want to change that name, you have to then change it in the Create, Insert, and Drop locations.
Would be nice if this defaulted as a snippet placeholder so that editing one would edit the other two as well.3 votes -
Copy results grid data to Excel as an XML spreadsheet to preserve data types
When working on a management server with SQL Prompt and SSMS, we usually don't have Microsoft Office with Excel installed there. This makes it very cumbersome to use the current feature of SQL Prompt to export grid results to an Excel file as there is no application available on the server to process the file.
Instead, I often use a very nice feature in SSMSBoost that copies to grid results data to an XML spreadsheet which can then be pasted into Excel on your client, preserving data types. The regular copy/paste from SSMS to Excel only copies text data from…
5 votes -
Open in Excel / Export to Excel - Choose file location for file creation
Currently the files write out to a temporary file location. Add pane in settings window to change the location (e.g. a folder in my one drive that is not read only)
3 votes -
Add or remove square brackets (easily!)
Have buttons to add/remove square brackets rather than tucked away under Options, so they can be toggled on or off easily.
And/or move the square brackets option out of Options and into the actual formatting style (like the option to remove additional whitespace) so it can be saved and shared as a template
6 votes -
Installer should remember if I installed last to SSMS only and default to that
I am installing SQL Prompt into SSMS only. every time I run an update I need to change the install location to SSMS only (from SSMS and VS). Please make the installer remember my selection and default to it
2 votes -
Align SET statements around = sign
I am a brand new user (1 day) for SQL PROMPT. I managed to get my parameter statements to align, but there is no option on my custom formatting style to align my set statements. See the attached jpg. Trying to get it to look like the yellow highlighted area.
6 votes -
When using the "Qualify Object Names" feature, show a drop-down when multiple possibilities exist
e.g.
declare @1 table (a int, b int)
declare @2 table (a INT, b int)SELECT a, b FROM
@1 a
CROSS JOIN @2 bHere there are 2 possibilities for columns a and b, however SQL prompt only suggests the second one. Both should be shown and the user given the chance to choose.
SQL Prompt does not recognize the ambiguity nor alert the user to it (although Microsoft Intellisense does flag the ambiguity). This can result in the user selecting the wrong alias (since only one is presented, apparently the last one found) which can result in hard-to-debug…
1 vote -
Check is left and right are the same, and always true: like Where [Column]=[Column]
Check if left and right are the same, and so always true:
like Where [Column]=[Column]
or Where @var1 = @var 1 ..this is a big mistake .. just happened to me ..
5 votes -
Snippet placeholder for currently selected object in Object Explorer
Like the snippet placeholder $SERVER$ inserts the name of the connected SQL server and $DBNAME$ inserts the name of the connected database I would like a placeholder $OBJECTNAME$ that will insert the name of the object already selected in Object Explorer.
1 vote -
Bulk Action - Qualify Object Names
Run Qualify Object Names operation without having to open each file in SSMS.
I want to be able to apply best practices in bulk. Opening individual files and running qualify object names is very time consuming. It would be nice to do this operation in Bulk on a folder or list of files.
4 votes -
Allow SQL PROMPT to resolve constants in an ORDER BY clause
If I create a query with an ORDER BY clause such as ORDER BY 1, 2; SQL Prompt will flag the ORDER BY and report ORDER BY clause with constants.
It would be nice to have an option to have SQL Prompt replace the constant(s) with the correct column names.
4 votes -
Add AI assistance
As AI powered tools like codepilot, kite or tabnine are on the rise, It would be so great to add an AI assistant to SQL Prompt to support developers on their way to write t-sql code effortless.
3 votes
- Don't see your idea?