insert into A.dbo.TUser
select NEWID(), LoginName=ADUser.Aduser,'',UserName=V_User.UserName,Sex=V_User.UserGender,Mobile=V_User.UserMobile,Phone=V_User.UserTel,
Email=V_User.UserEmail,'2017-3-27',LastOnlineTime=V_User.[UserOnboardDate],DynamicCode=ADUser.DynamicCode
from B.ADInformation as ADUser inner join C.dbo.v_UsersFull as V_User on(ADUser.Aduser=V_User.UserCode)
where (ADUser.Aduser <> '' or ADUser.Aduser is not null)