Posts
Sort by recent activity
Feature Request: Use actual column order
I often put a lot of columns towards the "end" of my tables because they're infrequently used or contain audit-type data. However, a lot of times, these are alphabetically first.
I know that at one...
Bug: Cross-database queries change "current" DB
Looks like when we do cross-database queries, SQL Prompt 5 loses some of the information or switches its DB context. When trying something like:
select *
from dbo.TableA as a
JOIN NotCurrentDB.dbo...
[Bug?] Select * from Store as s <return>
Not sure how to categorize this. I don't think this is an option that I've missed, but this didn't happen in 3.x. When I type something like:
SELECT * FROM St -- and then autocomplete so it beco...
INSERT MyTable (Col1, {Exception}
This seems to happen pretty regularly. I start manually populating columns for an INSERT Statement because I don't want to insert data for all columns. I start getting a drop-down of available colu...
See lots of red lines?
Not sure what's going on here, but I see a lot of red lines when trying to write T-SQL Code in SSMS 2008. At one point, I would arrow up or down and the red lines would move around the screen as I ...
SQL Backup and SQL Compare?
Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. Is that correct or...
[FR?] Columns in table take precedence over functions?
Another issue I run into often. We have a couple of tables that have "Is_Enabled" or "Is_Active" or similar as column names. When I start to type out to get down to that area, the "IS" operator j...
[FR] Ability to sort by physical column order?
I know I've requested this before, but was wondering if this is on the roadmap or something that will be released prior to SQL Prompt 4.
Reason I ask is that an awful lot of times I start typing a ...
Bug - Can't seem to refresh cache after deleting for DB?
This is an odd behaviour - using the latest release of SQL Prompt 3.6. I was trying to refresh the cache of an existing database and kept getting a problem with the security - a context error that...
Bug - SQL Prompt 3.6.0.82 - aliases prompt for connections
This was around in 3.5 as well. When I type a new query:
SELECT * from MyTable as m
where m. <-- Problem occurs here
I get a prompt to log in to "m" or "Server.m". I hit Escape, go back and hit...