Posts
Sort by recent activity
Confirmed bug in formatting
Hi Aaron,
Here is a quick report for a bug. I have no time at the moment to isolate it further, hope you can reproduce
When I format the statement below the
ORDER BY [Exists] ,
Gets transformed to
...
Matching multiple fragments of an object name
Hi,
Most of the time Prompt reads my mind and comes with the sql object I had in mind when
- typing a single fragment of the name
- typing multiple fragments of the name
For example, the sproc
usp_...
See through schema when crossing databases
There is a small inconsistency when resolving object names but it makes a big difference.
Prompt "sees" trough the schama's when typing something after Exec
For example when typing "Schedul" it sug...
No Intellisense after temporary mistake
Another report. I keep them coming if you don't mind
====
DROP TABLE Temp
CREATE TABLE Temp (col1 INT)
SELECT
*
FROM
Temp t
WHERE
1 = 1
AND t. -- *
AND t.col1 = 6
AND t. -- no intellisense
====
The...
No suggestion before analytical function
I took the time to come up with this self contained example.
Can you reproduce ?
SELECT
*,
d. -- no intellisense
COUNT(*) OVER (PARTITION BY col1) AS myCount
FROM
(SELECT
1 col1,
'A' col2
UNION ALL...
No intellisense when alias is in front of column + CASE
We bumped into an issue where there were no column suggestions and took the time to write an isolated example.
SELECT
ca. -- no intellisense
BalancePreviousBusinessDay = CASE WHEN 1 = 1 THEN '1'
EL...
No intellisense when using a view multiple times + repro
We have pinpointed a problem with the latest version (6.2.0.241) and took the time to come up with an isolated repro
-- problem seems to occur only with views
-- problem occurs when you refer to a ...
Join candidate not showing up
Hi,
I am using the northwind database.
When I type
SELECT * FROM Categories INNER JOIN
I expect that the Product table is suggested.
Is this normal?
Learn prompt your naming convetions?
Hi,
Great tool and its the first sql intellisense product that does what I want
Well, almost cause I got excited when I saw the feature "TAbles join by matching column names". Problem is a lot of ...
Difference between name exposed / internal
This gives me sync trouble :
The difference in name makes redgate think the object isn't at the other server so it wants to sync it in vain.
Is this a known problem. I've seen it happen a few times...