Posts
Sort by recent activity
Make SQL Prompt dialogs go away when the escape key pressed
Some (I don't know if all) SQL Prompt dialogs do not go away when the escape key is pressed. The user has to click the close button on it. It would be nice if the escape key triggered closed the ...
Error message box always appears when opening a SQL Solution
We use SQL solutions in SSMS to access SQL code. Every time we open one we get the following error message by SQL Prompt:
SQL Prompt cannot retrieve objects from <database name>. Possible reason...
Blank Aliases No Longer Valid in Version 4.0.3.12
We do not use the aliases suggested by SQL Prompt, but do use custom aliases for some (but not all) tables. Why are blank aliases no longer valid? It was in the previous versions. With "Assign A...
Not recognizing variables until new line
We create our variables like this, initializing them on the same line:
DECLARE @this_is_a_variable_with_a_long_name int; SET @this_is_a_variable_with_a_long_name = 0
Is there any way to have SQL Pr...
Configure SELECT *<TAB> results
In version 2.0 we could change the format of the results of pressing tab after a SELECT * statement. Can this be added back to version 3? My company's standards are to put the commas in front of ...
Built-in data types case setting not honored for char
The built-in data types case setting lowercase is not honored for char data types.
It happens when I press spacebar instead of tab after typing the data type in declaring variables (which I seem to...
Being able to set the case for data types is great!
Being able to set the case for data types is great (the standard here for data types is lowercase)! However, when I type "DECLARE @x ch" the menu comes up, but then when I select CHAR, it turns in...
How about an option to not have an alias set for a table?
I really like using the aliases, but in some cases, I am happy with the table name, and do not want an alias generated for the table. So instead of "table_name table_name_alias", I would just like...
Current Observations/Problems/Quirks
Here are my current observations/problems/quirks I have found with the new V3 beta that I have not yet seen on the forum. Note that I am using Microsoft SQL Server Management Studio for developmen...
SELECT *<TAB> Order of columns follows Candidate List Order
When I press <TAB> after typing "SELECT *", the order of the columns seems to follow whatever is in the candidate list order setting in the formatting section of the candidates tab. While I want t...