Activity overview
Latest activity by Ashwinks
Add my vote..
SQL 2005 and 2008 are going to be using this feature heavily. This is definitely a MUST-HAVE feature. / comments
Add my vote..
SQL 2005 and 2008 are going to be using this feature heavily. This is definitely a MUST-HAVE feature.
Tanya,
Thanks for the acknowledgement. Its not often that a company owns up to a mistake, especially when they have to confess that they do not have a solution ready at hand. Thank you for that. Appreciate it.
I hope you would put this up as a hotfix asap, rather than a service pack release.
Another issue that I found was the way it provides suggestions. Consider the below query:
Select Customer.Name, Orders.OrderDate, Orders.Quantity, Orders.Total
from Customer INNER JOIN Orders on Customer.CustomerId = Orders.CustomerId
where Year(OrderDate) = 2009
In SQL Prompt 3.0, when I try to modify the select list, I used to get intelligent prompting of only the tables that are involved in the query, as soon as I enter a space after "Select" or a comma after an item in the select list. Now I dont seem to get that intelligent prompting, and instead, it seems to prompt on whatever characters I choose, and gives me options of all matching tables in teh database, rather than only the tables involved in the query in question.
That intelligent prompting, although subtle, was fantastic to work with. Can you look into that as well, please ? / comments
Tanya,
Thanks for the acknowledgement. Its not often that a company owns up to a mistake, especially when they have to confess that they do not have a solution ready at hand. Thank you for that. ...
I am having the very same issue. I find that now the "format" section under "Options" is greyed out because I am on the "standard" version. I dont remember having any limitations, especially in the options under SQL Prompt 3.0.
The indentation at various points was extremely intuitive in 3.0, and an enormous help and not having that in 4.0 is almost very disappointing. The speed in 4.0 is fantastic, so great job on that angle !
Could you please post a public note on how to get the indentation working ? / comments
I am having the very same issue. I find that now the "format" section under "Options" is greyed out because I am on the "standard" version. I dont remember having any limitations, especially in t...