What methods can be used to graphically create SQL queries?
In your opinion would graphical or written code present the most flexibility?
Which do you feel would be the best for a person to use?
Student, Microsoft SQL Server Management Studio offers a Query Designer dialog that allows graphical design of queries. Attached is a screen image I took of designing a simple SELECT between two tables in SQL Server 2005 Express Management Studio. This is how the application is described in the Books Online (September 2009) help documentation for SQL Server 2008 Enterprise Edition:, where it is now called Query Builder: ...
An overview of the methods that can be used to graphically create SQL queries, with a qualitative comparison between them.