SQLite Manager
-
Part 1 I'm using SQLiteStudio 3.0.5. It's OK, but one think I can't figure out is how to execute 2 queries AND have both their results show at the time time:
SELECT * FROM Table1;
[UPDATED - OOPS]
SELECT * FROM Table2This runs but only displays the results from Table 2. Part 2 Anyone know of a better tool? Thanks
If it's not broken, fix it until it is
-
Part 1 I'm using SQLiteStudio 3.0.5. It's OK, but one think I can't figure out is how to execute 2 queries AND have both their results show at the time time:
SELECT * FROM Table1;
[UPDATED - OOPS]
SELECT * FROM Table2This runs but only displays the results from Table 2. Part 2 Anyone know of a better tool? Thanks
If it's not broken, fix it until it is
SELECT * FROM Table1
Shows results from Table2?
The difficult we do right away... ...the impossible takes slightly longer.
-
SELECT * FROM Table1
Shows results from Table2?
The difficult we do right away... ...the impossible takes slightly longer.
Sorry, typo -
SELECT * FROM Table1;
SELECT * FROM Table2Only shows the results from table2. SQL Management Studio shows one table for each query
If it's not broken, fix it until it is
-
Part 1 I'm using SQLiteStudio 3.0.5. It's OK, but one think I can't figure out is how to execute 2 queries AND have both their results show at the time time:
SELECT * FROM Table1;
[UPDATED - OOPS]
SELECT * FROM Table2This runs but only displays the results from Table 2. Part 2 Anyone know of a better tool? Thanks
If it's not broken, fix it until it is
Not exactly sure what you're after here. If the tables are related then you need to join them on a common field and show the results as one query. If they are not related you can always use a cross join which will return rows from table1 combined with each row of table2: SELECT * FROM Table1 CROSS JOIN Table2 or SELECT * FROM Table1, Table2
-NP Never underestimate the creativity of the end-user.
-
Not exactly sure what you're after here. If the tables are related then you need to join them on a common field and show the results as one query. If they are not related you can always use a cross join which will return rows from table1 combined with each row of table2: SELECT * FROM Table1 CROSS JOIN Table2 or SELECT * FROM Table1, Table2
-NP Never underestimate the creativity of the end-user.
Nothing to do with joins... Paste the following into SSMS
SELECT * FROM Table1
SELECT * FROM Table2Press F5. The queries both run and both result sets are displayed. When I do this in SQLiteManager, only the last result set is displayed.
If it's not broken, fix it until it is
-
Nothing to do with joins... Paste the following into SSMS
SELECT * FROM Table1
SELECT * FROM Table2Press F5. The queries both run and both result sets are displayed. When I do this in SQLiteManager, only the last result set is displayed.
If it's not broken, fix it until it is
Does sticking GO; between the statements change the results?
Never underestimate the power of human stupidity RAH
-
Nothing to do with joins... Paste the following into SSMS
SELECT * FROM Table1
SELECT * FROM Table2Press F5. The queries both run and both result sets are displayed. When I do this in SQLiteManager, only the last result set is displayed.
If it's not broken, fix it until it is
-
Part 1 I'm using SQLiteStudio 3.0.5. It's OK, but one think I can't figure out is how to execute 2 queries AND have both their results show at the time time:
SELECT * FROM Table1;
[UPDATED - OOPS]
SELECT * FROM Table2This runs but only displays the results from Table 2. Part 2 Anyone know of a better tool? Thanks
If it's not broken, fix it until it is
What does this have to do with WPF or Silverlight?
-
What does this have to do with WPF or Silverlight?
Absolutly nothing. I posted in the wrong formum
If it's not broken, fix it until it is
