两表间拷贝数据
两张表是一样的,只是新老数据更新
update dbo.classmates
set LoginTimes = (select LoginTimes from dbo.classmates2 where classmates.id = classmates2.id )
两张表是一样的,只是新老数据更新
update dbo.classmates
set LoginTimes = (select LoginTimes from dbo.classmates2 where classmates.id = classmates2.id )