目前分類:SQL (2)
- Jun 16 Sat 2018 06:39
根據輸入的變數 Loop 分批刪除資料的 SQL
- Jun 16 Sat 2018 06:28
用Select找出一批資料後, 再按資料的每一筆進行更新作業
declare cursor cur is (select tc_pqf33,tc_pqf07, xx.tc_pqh01 as tc_pqh01 , xx.tc_pqh03 as tc_pqh03 , xx.max_tc_pqh06b as max_tc_pqh06b
from dg.tc_pqf_file pqf ,