SQL高级应用之同服务器上复制表到另一数据库中并实现去重复

前端之家收集整理的这篇文章主要介绍了SQL高级应用之同服务器上复制表到另一数据库中并实现去重复前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

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)

猜你在找的MsSQL相关文章