Ophir LOJKINE
563bc87959
* delegate statement preparation to sqlx The logic of preparing statements and caching them for later reuse is now entirely delegated to the sql driver library (sqlx). This simplifies the code and logic inside sqlpage itself. More importantly, statements are now prepared in a streaming fashion when a file is first loaded, instead of all at once, which allows referencing a temporary table created at the start of a file in a later statement in the same file. fixes #100 * remove temporary table usage mssql does not have "create temp table" * mssql permissions fix
7 lines
201 B
SQL
7 lines
201 B
SQL
drop table if exists my_tmp_store;
|
|
create table my_tmp_store(x varchar(100));
|
|
|
|
insert into my_tmp_store(x) values ('It works !');
|
|
|
|
select 'card' as component;
|
|
select x as description from my_tmp_store; |