Comments
Sort by recent activity
Michelle,
Thanks for the reply. I realized I've posted this in the wrong forum, but the same is true for SQL Data Compare. Could you open a ticket for that product as well?
Thanks,
Patrick / comments
Michelle,
Thanks for the reply. I realized I've posted this in the wrong forum, but the same is true for SQL Data Compare. Could you open a ticket for that product as well?
Thanks,
Patrick
I'd like to throw in a vote for this change as well. We're looking at using SQL Prompt to reformat our code and having BEGIN/END on the same tab stop is the IF/ELSE would be preferred. / comments
I'd like to throw in a vote for this change as well. We're looking at using SQL Prompt to reformat our code and having BEGIN/END on the same tab stop is the IF/ELSE would be preferred.
After some further investigation, it does appear that SQL Prompt only automatically provides a table list based on FK constraints. If you start typing a table name and hit ctrl-space, the popup list comes back. It would be nice to make it an option to have it disregard FK requirements and show all tables after JOIN .
Patrick / comments
After some further investigation, it does appear that SQL Prompt only automatically provides a table list based on FK constraints. If you start typing a table name and hit ctrl-space, the popup lis...
I just ran into this using aliases for something like:
select * from foo f where f.
and there were other table names that start with f, so it completed the first one. Funny thing, f.column_name was lower in the list.
Maybe SQL Prompt should sort those to the top or recognize the use of an alias and not perform completion, but instead perform another suggestion after hitting "."
Patrick / comments
I just ran into this using aliases for something like:
select * from foo f where f.
and there were other table names that start with f, so it completed the first one. Funny thing, f.column_name was...