項(xiàng)目需求：將數(shù)據(jù)庫(kù)Whir_ezMall_Full中的表Whir_Member的數(shù)據(jù)遷移到數(shù)據(jù)庫(kù)Whir_ezMall_Full_c中的Whir_Member表，已存在的ID記錄則不插入。
SQL語(yǔ)句：
代碼如下:
INSERTINTOWhir_ezMall_Full_c..Whir_Member(MemberID,LevelID,Account,MemberPWD,Email,Integral,MemberName,MemberStatus,Sex,Birthday,Area,Adress,ZipCode,Tel,Mobile,SaveQuestion,SaveAnswer,CreateData,LastLoginData,ImgUrl,LimitIntegral,IntegralBeginTime,IntegralEndTime,memberType,BankType,BankRegion,BankAddress,BankAccount,BankName,IsQQ)
SELECTMemberID,LevelID,Account,MemberPWD,Email,Integral,MemberName,MemberStatus,Sex,Birthday,Area,Adress,ZipCode,Tel,Mobile,SaveQuestion,SaveAnswer,CreateData,LastLoginData,ImgUrl,LimitIntegral,IntegralBeginTime,IntegralEndTime,memberType,BankType,BankRegion,BankAddress,BankAccount,BankName,IsQQFROMWhir_ezMall_Full..Whir_Member
WHEREWhir_ezMall_Full..Whir_Member.MemberIDNOTIN(SELECTMemberIDFROMWhir_Member)