Posts
Sort by recent activity
Bug with Output Clause
I am running 6.4.1.52 and I have found a couple of bugs when using the Output clause.
Open SSMS and enter the following
Use AdventureWorks
Go
Declare @NewContacts table (ContactID int)
Insert Int...
Beta: Format SQL may remove too many double quotes
I just got some SQL from an associate that they asked me to review. Of course the first thing I did was reformat the SQL, and it broke the SQL. The SQL was similar to this (more complicated, but th...
Declared table names getting quoted
Another issue I have found (in the current live code as well as the current beta) is that in certain circumstances declared table names get quoted with square brackets.
It's rare and I was only rem...
Bug with Output clause in latest beta
Enter the following snip of code into SSMS.
Use AdventureWorks
Go
Update Person.Address
Set AddressLine1 = AddressLine1
Output Deleted.*,
Inserted.*
Now, go to after the asterisk in...
"Press TAB to expand wildcard" doesn't always work
Open a query windows and do a ssf.
Select *
From master.sys.sysobjects As s
Go up to the asterisk and back it out and type s.*. You will be prompted with a tooltip to "Press TAB to expand wildcard...
Inconsistent formatting in 6.4.0.404
I have noticed some inconsistent formatting when there are and/or'd Boolean expressions in a Case vs. Iif.Case When ( c.TerminationDate < '01/01/2008'
And n.EntityTypeID =...
Seeing too many suggestions in 6.4.0.206
I have begun to notice that I have been seeing too many suggestions in my intellisense. For example, I have a table "dbo.Committees" (which yields an alias of "c"), a view called "dbo.CurrentCommit...
"Format > Case" bug
In 6.3.0.354 you started supporting CamelCase options (Great!!!), but I wanted my built-in data types to be lowercase. Not all data types are being handled correctly (in context of where they are u...
More Project or "Generate Documentation" options, please
Hello,
I like the fact that I can choose if I want to have the T-SQL in the documentation or not, but I think it would also be nice to have the option of turning on or off other sections too.
For e...
The new .doc type is great! But...
Hello,
I just installed my new SQL Doc 2 and I think the new .doc type is great!!
Now, I have a suggestion or two .
How about a "legend" to explain what the different symbols mean to someone who...