摘要:
@echo %date%
@Set Year=%date:~10,4%
@Set Month=%date:~4,2%
@Set Day=%date:~7,2% @Set CurrentDate=%Year%_%Month%_%Day% @set BaseDir=D:\temp
echo %CurrentDate% rem 删除%BaseDir% 下的子目录,除了 %CurrentDa... 阅读全文
摘要:
merge into users a
using temp_users b
on (a.userid = b.user_id)
when matched then update set a.password = bb.password, a.name = b.name
when not matched then insert (a.name, a.pass... 阅读全文