Posts
Sort by recent activity
Where is ParserLookBackDistance in options?
Hi
I just updated to 6.4.0.657 because ParserLookBackDistance and ParserLookAheadDistance have been added to the options menu. Only thing is, I can't find them! Can someone point me in the right di...
Formatting of IIF does not respect wrapping setting
I would expect an IIF to be able to break at the commas at the very least. After all it is a macro for a CASE statement.
Interestingly it is breaking on arithmetic operators in the THEN and ELSE cl...
A duplicate definition was found for the extended property d
A duplicate definition was found for the extended property dbo
I'm getting this on my commit changes tab. I can't send an error report because I'm getting a proxy authentication error.
Any ideas on...
closing parenthesis of IIF function always on new line
closing parenthesis of IIF function always on new line
doesn't appear to be affected by any of the preferences
6.1.0.67
Poor handling of OVER clause
6.1.0.27
I'm not very happy with the way that window functions are handled. It's been like this for quite a while now and as I'm using them more and more it's getting to be a bit of a hassle. I've ...
SQL Prompt 6.0.0.412 EAP - Object reference not set
Object reference not set to an instance of an object. (Microsoft.VisualStudio.Editor.Implementation)
SSMS 2012 11.0.3128.0
I use solutions and projects within those solutions. The one I'm currently...
FOR clause formatting odd...
I am seeing a FOR clause get some odd formatting.
My code is:
SET @cmd = ( SELECT sg.Column0 + @crlf
FROM dbo.staging_generic sg
WHERE sg.RowNumber > 1
FOR XML PATH&#...
INSERT column order in multi-statement TVF
SQL Prompt version 5.2.8.2
SSMS 2005 9.00.4035.00
Trying to write a multi-statement TVF and noticed that the INSERT inserter is getting the columns mixed up. This does not happen in ad-hoc SQL or S...