Forum Discussion
RE: two query's on same databse
Anonymous
I don't think so. You could, after creating the first query in the query editor:
1. Duplicate it
2. In the duplicated query: go to the first Step: 'Source' and open it on the configuration sign on the right, that symbol looking like a tooth wheel
3. Enter your SQL query 2 there.
Maybe it will be a bit faster, but not by much.
Anonymous
Can you not enter all the queries at once in the query editor? Under advanced option in the menu where you connect to the SQL server
so how to differenciate two queries there?
Anonymous
What are the two queries that you want to carry out? Can you copy them here?
In any case, I think it might be a good option to do this in the query editor. There you can also, under Home, select "New Source"-->SQL Server and you'll get the same menu as shown above with Server, Database, etc.
You can enter your query under 'Advanced Options' as we've seen and then that query will be assigned to a table. You can follow the same procedure with your query 2 and it will be assigned to another table.
exactly im doing the same. but every time i need to follow all steps right?
to avoid this is there any other option to click new query and enter that and execute?
Anonymous
I don't think so. You could, after creating the first query in the query editor:
1. Duplicate it
2. In the duplicated query: go to the first Step: 'Source' and open it on the configuration sign on the right, that symbol looking like a tooth wheel
3. Enter your SQL query 2 there.
Maybe it will be a bit faster, but not by much.