Posts
Sort by recent activity
Uninstall annoyances
After popping up to tell me that it was expired (even though I had it turned off, which I thought was a bit strange), I decided to uninstall SQL Prompt. I was not surprised that I was asked to clo...
DDL?
Should we be testing DDL? I can think of lots of areas SQL Prompt could be useful here -- but currently it doesn't appear to be working at all, so I'm not sure if I should file reports here...
Can...
Candidate list when working with SPs
If I type in "EXEC ", the candidate list pops up with a list of stored procs. Good. But now if I select one and type space, no candidate list pops up. I expect to see a list of the available par...
Problems with aliases
Type:select *
FROM [Sales].[SalesOrderHeader] soh
WHERE soh
Type a "." at the end of the "WHERE soh" line.... and get a list of all database objects.
Another one:select *
FROM 	...
JOINs: Need a table list
Type:select *
FROM [Sales].[SalesOrderDetail] AS sod
join
Hit space. Result: List of columns from SalesOrderDetail. Expected: List of tables.
Update: Once again, this behavior i...
WHERE clause inconsistency
First, type in:select *
FROM [Sales].[SalesOrderDetail] sod
where
Hit space, and you get a list of columns from SalesOrderDetail. Good.
But what if I want to do the WHERE clause...
Synonyms?
The product does not appear to support synonyms:create synonym r for sales.salesorderdetail
...SELECT * FROM
... No "r" in the list.
A few comments on INSERTs
In AW:insert [Person].[Address]
(
Now hit Enter and Tab, and you get a column list for Person.Address. Great. But what about multi-select in that list? And how about, when ...
Unhandled exception!
Here's a fun one...
Set up your connection for AdventureWorks, and paste in the following:insert [Person].[Address]
(
[AddressLine1]
[AddressLine2]
)
No...
Disappearing cursors
I stepped away from my computer for a few hours, came back and hit F5 on a query in SSMS. A little SQL Prompt box opened at the bottom righthand corner of the window that said, "checking permissio...