Design Query in Editor bug

July 3, 2008

Ok, so real database developers don’t use the graphical “Design Query in Editor”… yeah, I know. Sure, there’s the odd time when you’re typing a query and you don’t have an Object Explorer (eg, in SSIS) and a moment of weakness sees you hit “Build Query” to save some typing, but in general I encourage people to write their queries in Management Studio SSMS and then copy them into the SSIS dialog. I was showing someone some of the frustrations I have with the graphical editor, and came across a real beauty – repeated predicates.

I logged a bug at the Connect site, where I wrote the rest of the details. You should vote for this – there may be a time when you click “Build Query” to avoid some typing, and you don’t want to look like an idiot for repeating the same line multiple times.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=352874

This Post Has One Comment

  1. Reginald Spanner

    My kids repeat the same line multiple times in their queries, got a fix for that?

Leave a Reply

LobsterPot Blogs

Blog posts by Rob Farley and other LobsterPot Solutions team members.

Search