摘要： @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... 阅读全文