Hi,
Whenever i try to run multiple update queries at the same time , i will encounter this error "Characters Found After End Of SQL Statement".
update Table1
set ColumnA="A"
Where ColumnB="B";
update Table1
set ColumnA="C"
Where ColumnB="D";
Do any one has idea on how to overcome this?
I find online and some suggest that make a macro and run the queries in the macro.
BUT
I find out that the queries that i can put into macro does not support multiple update queries at the same time.
Does anyone has idea on this?