将sq_data1的UserInfo表复制到 test_data1的UserInfo里
Update sq_data1.dbo.UserInfo set ID=ct.ID, ParentId=ct.ParentId, UserName=ct.UserName, Telephone=ct.Telephone, Password=ct.Password, Email=ct.Email, Hits=ct.Hits, JobTitle=ct.JobTitle, CompanyName=ct.CompanyName, Address=ct.Address, AddDate=ct.AddDate, CusId=ct.CusId From sq_data1.dbo.cb_card c left join test_data1.dbo.UserInfo ct on c.ID = ct.ID where c.ID= 123456