var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: use SQL to generate SQL statements
Hi there, I have two questions about Access Sql.
1.Can we use SQL to generate SQL statements in Access2000?
I put this below sql statments in a query and ran it and got errors:
SELECT 'SELECT COUNT(*) FROM '||TABLE_NAME||';' FROM MYTABLES;
It seems that Access SQL doesn't accept '||'. Does access sql support the the concatenation.
2. Can we run multiple sql statments in a query.
If I run 'SELECT COUNT(*) FROM TableA;' it works fine. But If I run more than one statements in a query like below, I got errors.
SELECT COUNT(*) FROM TableA;
SELECT COUNT(*) FROM TableB;
Thank you very much in advance !
1. use & or + instead of || (i can't remember which)
2. no, just one at a time -- however, you could run this:
SELECT 'Table A', COUNT(*) FROM TableA
SELECT 'Table B', COUNT(*) FROM TableB
SELECT 'Table C', COUNT(*) FROM TableC
up to maybe 16 of them? 255 of them?