sql语句:
代码如下:
INSERT INTO Whir_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)
SELECT MemberID,IsQQ FROM Whir_ezMall_Full..Whir_Member
WHERE Whir_ezMall_Full..Whir_Member.MemberID NOT IN (SELECT MemberID FROM Whir_Member)
原文链接:https://www.f2er.com/mssql/63265.htmlSELECT MemberID,IsQQ FROM Whir_ezMall_Full..Whir_Member
WHERE Whir_ezMall_Full..Whir_Member.MemberID NOT IN (SELECT MemberID FROM Whir_Member)