Re: GUI for stored procedures in MySQL?

[Shawn Green]

David,

I think you are confusing views, SQL statements, and stored procedure.

A view is a query whose results are presented in a manner that allows those results to be used almost exactly as though they exist as a table. Views are uniquely named and reside on the server.

A stored procedure is a compiled SQL statement or sequence of statements that resides on and executes within the server that is referenced by a unique name. Typically stored procedures (SPROCS) are used to perform maintenance or migration or to automate certain complex tasks so that the end user (or some other client program) doesn't need to perform several statements in sequence. That saves round trips to the server and noticably improves performance when implemented correctly.

A SQL statement is just that, a statement written in a SQL dialect (each vendor's server has their own dialect). It may be a query ("SELECT ...") , a schema modifying statement (like "DROP TABLE..." or "CREATE VIEW...") , or a data modifying statement (like "INSERT ...")

The tool you are probably using within the MSSQL Enterprise Manager to test your statements is called "Query Profiler". There might be another tool in the EM that I may have never used (you mentioned graphically linking databases) similar to MS Access's "Query Builder". Which tool are you looking to replace?