我用SQLite寫的 create table tb (item integer, num integer, sn text); insert into tb...
SELECT * FROM user WHERE address LIKE ('%ABC%','%DEF%','%GHI%') 可以改為 SELECT * F...
如果H3是日期的話,在I3寫=countifs(C:C,">="&H3,C:C,"<="&e...
建議把CM中的,CONF_NO = 003的PROJ_NO由A,B改為C。再在PM中新增 INSERT INTO PM (PROJ_NO, USERS) VAL...
https://docs.python.org/3/library/re.html#re.findall
array可以不用先決定大小。我自己都這樣用: dim ary as variant if isarray(ary) then redim prese...