Posts
Sort by recent activity
Schema and Db with the same name: no Db suggestions
Hi,
i don't know if its by design but if there is a schema in the current database that has the same name as a database then suggestions for the other database will not show up. Took me a while to ...
Connect to a server from (pseudo?) tsql
Hello Support,
When I learned about sqlcmd mode in ssms I got my hopes up that I could switch in my tsql from server. Something that I do many times a minute :
:CONNECT ServerX
It turns out that ss...
Support for guid's in snippets
Hi Aaron,
Is there a placeholder for generating a guid? This would be super helpful
Currently we have TIME,MACHINE etc
Can you add a GUID or UNIQUEIDENTIFIER ?
Thanks, Tom
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 ...