277 results found
-
anywhere in the script file if the last line below is used it causes an error. CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WI
sequences in sql 2012 is not supported by the formatter
anywhere in the script file if the last line below is used it causes an error.
CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WITH 1 INCREMENT BY 1 NO CYCLE CACHE 10
go
DECLARE @Seq INT
SELECT @Seq = NEXT VALUE FOR [dbo].[ReportComparisonSeq]4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Support MERGE
SQL Prompt sometimes works on some parts, e.g., it will give a list of columns for MATCHED but only for the TARGET table, never the source... It also suggest tables when coding a list of columns for an INSERT or it quits making any suggestions at all. This is a very hit-and-miss situation and very frustrating.
As the MERGE statement has been around since SQL Server 2008, it's very surprising/disappointing that, considering MERGE to be a STANDARD part of the DB Engine, SQL Prompt is this far out of date... FOUR YEARS AND COUNTING...!
Please "get current" :-)
28 votesWe’ve improved MERGE statement suggestions in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
Please let us know if you have any examples where you think suggestions could be improved!
-
comment block
I would like a feature to place a hilited block of code into a comment block /**/ - rather than having inline comments (helps when capturing the running sql in monitoring tools)
4 votesThe latest version of SQL Prompt has the $SELECTEDTEXT$ placeholder which allows you to use the current text selection in your snippets. So to surround a selection with a comment block you could create a snippet similar to: /* $SELECTEDTEXT$ */
-
Please add a function key to reopen the sqlprompt box.
Here’s what’s happening: I am typing along and I hit space instead of tab which does not complete the fill in (I actually like this so I don’t want to add the space as a completion key). I would like a mappable key combination to get the prompt to re-open.
2 votesCtrl+Space will bring back the suggestion box, but also the latest build of Prompt will bring it back if you just continue typing after you left off (if you didn’t purposely hide it with esc)
-
SqlPrompt doesn't understand the Syntax of an update-statement when the table-to-be-updated is aliased
Hi!
Please consider this statement
update t1
set t1.value = t2.value
from Table1 t1
join Table2 t2
on t1.ID = t2.IDWhen you have the cursor in the set-block of the statement, SqlPrompt doesn't know what 't1' means and which columns t1 has.
30 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SQL Tab Magic - Connection attempts
When loading management studio it would be great if tab magic could get a list of the required connections before the tabs are loaded and test each one silently to see if a connection would be possible (i.e. host is available) If the host is available then prompt for login once per host, if host is not available simply load the tab as not connected.
This would make the experience much nicer as at the moment if I had say 15 tabs open to a host that I am no able to connect to (I work on multiple sites) I…
8 votesSQL Prompt 6.1.0.71 will try a silent background connection before getting SSMS to connect the query.
-
SQL PROMPT 5 - Simple, but toggle indenting of else if statements
Allow the option to NOT indent else if statements. Each of the ELSE IF statements gets further indented and for large SQL it becomes indented off the screen. I can imagine this pattern could apply else where but for this specific use case our STPs that have this condition i simply can't format the sql because it requires me to horizontally scroll. Allowing me to disable indenting ELSE IF statements would solve this problem instantly.
21 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
SQL Tab Magic - Recently Closed Tabs navigation
When I click on 'Recently Closed Tabs' I get a window showing 20-ish closed tabs and their contents. If I resize the window, it fills with more, so I know that further history can be accessed.
I understand that the best way to find 'old' queries is to type in the search box to try and filter the history, but sometimes (and it is only sometimes) I just want to scroll down the history and see all the closed tabs. Not saying all the history should be loaded - I guess that would take a lot of memory, but it…
5 votes -
Format selected code
Formatting a section (selected code block) with CTRL+K, CTRL+Y). This would allow me to highlight a section of a proc and format it to my liking and leave the (abomination) of the proc body untouched.
3 votes -
Option to place Table names on the same line as the keyword
Currently, no matter what settings are applied, table names are always placed on a new line, for example:
SELECT
ID,
ThingFROM
TableNameJOIN
OtherTableName
ON blah=mooWHERE
something <> something elseMy personal preference is for:
SELECT
ID,
ThingFROM TableName
JOIN OtherTableName
ON blah=mooWHERE something <> something else
Please can we have an option to achieve table names on the same line as their action (FROM / JOIN)
13 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Allow renaming of variables easily
In the T-SQL editor it'd be really good if you could rename variables easily. In VS, if you use Resharper clicking on a variable and hitting F2 allows you to rename that variable and all occurrences of it easily. It even searches strings and comments and offers these as an option
22 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Enable prompting within a raiserror()
For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions".
Sample:
RAISERROR('Not at 12hrs UTC - time is %s',0,1,@<<Nothing-here>>) WITH NOWAITAlso reported as a defect on the SQL Prompt Forum
2 votesThe latest version of Prompt should give you suggestions within a RAISEERROR
-
Automatic semicolons
Include an option when reformatting SQL to automatically add semicolons at the end of each statement if they are missing.
While in most cases SQL Server 2005 and 2008 don't require this, the 2008 docs mention that a future version might.
and it may also be helpful if trying to move code from SQL Server 200x to a dialect which does require them.85 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows
Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows. This would be a very helpful feature to keep data types consistent throughout a database if one doesn't want to set up a user data type for each and every column that stores data types with additional parameters like, for instance, the scale and precision.
11 votesThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Add support for the ROWS|RANGE clause (part of the OVER clause enhancements) in SQL Server 2012
SQL Prompt does not recognize the new ROWS | RANGE keyword additions to the OVER clause in SQL Server 2012
6 votesROWS and RANGE are supported in SQL Prompt 6
-
Line up type declarations
I would like an option to align the type declarations, for example when declaring the columns in a table variable I currently get:
DECLARE @MyExample TABLE
(
MyCol1 INT ,
MyOtherCol VARCHAR(10)
)Which I would quite like to see laid out as:
DECLARE @MyExample TABLE
(
MyCol1 INT ,
MyOtherCol VARCHAR(10)
)The same is true for all other places where I'm declaring, so the parameters for a procedure for example
12 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Don't expand wildcard within EXISTS
Don't expand wildcard occurrences within EXISTS clause.
WHERE EXISTS(SELECT * FROM tab1)
should not expand to
WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)5 votesSQL Prompt 6.2 doesn’t expand wild cards in exists statements, you can download it from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add support for spatial functions/methods
Need Intellisense for the spatial functions and geography/geometry data types, especially since they are case sensitive, and annoyingly a mixture of upper and lowercase.
7 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Ability to set "Show schemas" as the default option for the candidate list
When object names appear in the candidate window for an autocomplete, the schemas are not shown by default. Clicking on the the arrow in the bottom left of the window will show them, but this setting is not remembered so you have to do it each time. Also there's no keyboard shortcut that I can find to do this. Add the ability to set this popup to show the schema names by default.
7 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Please provide intellisense even when not in the current database
In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)
1 voteSQL Prompt now supports suggestions from other databases when using the three part convention.
Kind Regards,
The Prompt Team
- Don't see your idea?