Re: StoredProc: How to pass 'table' as argument ? thanks for answer.
I Solved this in a little different way
with Temporary Table Engine=Memory
So the table name is static 'temp'
before execution of function i dynamicaly create table in memory then
execute function on temp and at the end i drop the table
so i dont have to pass a table to function.
But programing this way is a global variable programing like in visual basic
....
Could lead to errors in recursive functions ....
It is pretty hard for person how use OO programing only switch back to
procedural programing in SQL Stored Proc....
drop table if exists temp;
CREATE temporary TABLE temp ENGINE=Memory
Select md5(concat(
CASE WHEN Indeks NOT LIKE '' THEN Indeks ELSE '' END,
..................................
)) AS CRC32_DATA From CountryE order by CRC32_DATA asc;
Select GetSelectMd5() as MD5;
drop table if exists temp; |