下面是使用java腳本的for回圈的存盤程序
create or replace procedure test()
returns varchar
language javascript
execute as caller
as
$$
for (var i = 1; i<= 10; i )
{
var command8=` update table a set a.c1='some' from table b where a.source='gg' and b.c2=a.c2 and b.c3=a.c3 and (datediff(year,date(a.etl_create),current_date())= '" i "')`
var stmt8=snowflake.createStatement({sqlText: command8});
var rs8=stmt8.execute();
}
uj5u.com熱心網友回復：
要將變數替換為模板文字，請使用${variable}.
var command8=` update table a set a.c1='some' from table b where a.source='gg' and b.c2=a.c2 and b.c3=a.c3 and (datediff(year,date(a.etl_create),current_date())= '${i}')`
uj5u.com熱心網友回復：
使用出價變數：
for (var i = 1; i<= 10; i )
{
var command8=` update table a set a.c1='some'
from table b
where a.source='gg' and b.c2=a.c2 and b.c3=a.c3
and (datediff(year,date(a.etl_create),current_date())= :1)`
var stmt8=snowflake.createStatement({sqlText: command8, binds:[i]});
var rs8=stmt8.execute();
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/393476.html