SqlServer导入大文件Sql

sqlcmd -S "192.168.1.218" -U "sa" -P "1qaz~xsw2" -d "SispMain" -i "G:script.sql"

 Oracle导入Tmp

imp orcl/orcl@orcl full=yes file=D:jddatabak20180413_linux_0.dmp

Merge语法

Merge into [dbo].[DisabledInfo] AS T
Using [dbo].[DisabledInfoBak] AS S 
ON T.IdNumber = S.[IdNumber]
WHEN MATCHED 
THEN UPDATE SET T.[Nation] = S.[Nation];