Posts
Sort by recent activity
Bug: table-valued function output columns are prompted in the parameter list
SQL Prompt suggests the output columns of table-valued functions as as parameter values to the function itself.For example, with this code, place cursor after "dbo.foo(x" and hit Ctrl-Space. SQL Pr...
row_number() returns bigint, but SQL Prompt displays int
The summary popup for the row_number() function reports that it returns int, but it actually returns bigint.select row_number() over (order by o.object_id)
from sys.objects o
ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER
If a GO statement is not preceded by a newline, e.g. is first text in a query window, the autocomplete suggestions for a subsequent ALTER will exclude FUNCTION, PROC, PROCEDURE, VIEW, and TRIGGER, ...
table name prepended to column names in INSERT column list
If the "Qualify column names with table name" option is set, SQL Prompt incorrectly qualifies column names in an INSERT statement's column list.
For example, for table 'Foo' with column 'FooID', if...