Posts
Sort by recent activity
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...
Missing Formatting when pressing <TAB> after typing SELECT *
In Prompt SQL 1.x there was a way to set the formatting when pressing <TAB> after typing "SELECT *". Now it just fills in the columns in a long row, which becomes unwieldy quickly for large tables...
Variables and Parameters not appearing in list
Variables and parameters do not appear in the list anymore (it did in version 1.4). Also, typing @<CTRL-SPACE> used to bring up the list of variables and parameters, but does not now.
UPDATE: T...
Pressing Tab after a Keyword messes up the formatting
We format our code as follows:
SELECT
<TAB>table1.column1
<TAB>, table1.column 2
FROM
<TAB>table1
JOIN
<TAB>table2
ON
<TAB>table1.column1 = table2.column1
WHERE
<TAB>table1.column2 = 'xyz'
.
.
.
et...
Stored Procedures Not Appearing in List
Stored procedures do not appear in the list. I am using SQL Server Management Studio Express pointing to a SQL 2000 database. What do I need to do to get them to appear?
UPDATE: It seems to work ...