Limitations

The Visual Query Builder can assist with creating both simple and more complex SQL Scripts; it does however have some limitations. For queries containing the clause-types below, the design of these should be done using Microsoft SQL Server tools such as Management Studio.

The unsupported clauses include:

• PIVOT/UNPIVOT
• CROSS/INNER APPLY
• NATURAL JOIN
• VALUES

An example error when the CROSS APPLY clause is included in a query in the Visual Query Builder: