I've been using SQL Assistant to write queries and I want to use the SQL Query Builder feature in Studio Express. But when I try to open a query from SQL Assistant in SQL Query Builder, I get this:
"The sql cannot be parsed because it is either invalid or is not currently supported."
What am I doing wrong?
Is there another good visual SQL editor to use for this?
SQL Query Builder will attempt to load the database and table objects for the SQL query. Can you verify that the database, tables, and columns exist and can be located in the Data Source Explorer?