Skip to content
← dbForge Studio for SQL Server

How can we improve the product?

dbForge Studio for SQL Server: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Unfortunately, Query Builder does not support CTE yet.

Per your response "Unfortunately, Query Builder does not support CTE yet."

You added support for CTE's to the application, but left it out of the query builder. So, the result is even though there is support now for CTE's, you still can't fully use it.

Can you you just add the WITH statement to the query builder along with the other (SELECT, DELETE, etc....) keywords it supports?
Seems like it would be a quick, simple, change.

34 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
KCarterSr shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • MEngelbyDA commented  ·   ·  Report

    Hmmm...I've never used the query builder so at first I didn't even know what this request was talking about. I prefer to edit and run my queries in an SQL window (CTEs are supported very well in this type of window).

    If Devart can add CTEs to query builder, that will be quite the impressive bit of programming. Since CTEs at the simplest are joining of tables, but then there are beasts such as recursive CTEs. Yeah, that will be interesting to see in a UI.

  • Anonymous commented  ·   ·  Report

    It would be appreciated if CTEs could be completely implemented in query builder, or at least the minimal suggestion proposed by KCarterSr.

    At $150 (Aussie dollars aren't as strong as a couple of years ago), I see this as a premium product and so I think it's reasonable to expect full query support.