Posts
Sort by recent activity
Show SP parameter types incompatible with leading comma
When both of these options are enabled:
Inserted Code -> Objects & Statements -> EXEC Statements -> Show parameter data types
Format -> Commas & parentheses -> Commas in multiple-line statements -...
SP default parameters have wrong values or are NULL
When the option "Inserted Code" -> "Objects & Statements" -> "EXEC Statements" -> "Insert default value for each parameter" is enabled, inserted default values have either the wrong value or are in...
Forum link in V6 goes to V5 forum
In SQL Prompt 6, the menu item "SQL Prompt" -> Help -> "Red Gate Software Support Forum" goes to the SQL Prompt 5 forum, not the SQL Prompt 6 forum.
SQL Prompt 6.0.0.411 in SSMS 2012 (11.0.3128.0)
Table-valued parameters not included in prompt
Howdy, again. When I create a stored procedure or function with a table-valued parameter, the parameter variable is not offered in SQL Prompt prompts.
For example:
CREATE PROCEDURE MyProc @table_pa...
No prompting for columns of UTT table variables
Howdy, all. When I'm working with a table variable of a user-defined table type, SQL Prompt does not offer the variable's columns in the prompt.
Here's an example. When I typed the FROM clause, tab...