The two tables are the same, just new and old data update update dbo.classmatesset logintimes = (select logintimes from dbo.classmates2 where classmates.id = classmates2.id) SELECT output formatted (branch judgment) Word string Single quotes SELECT NAME Name, (Case When SEX = 1 Then 'Men' Else 'Female' End) Gender from Classmates Joint (2 Table) Update
Update Charge_mstset Receipt = Receipt - K.AllDotfrom Charge_Mst As C, Kao600099 As kwhere k.inuser = C.Userid
Table the reply in the "Reply Table" to the "Message" to "Message" Update Guestbook Inner Join Reply on Guestbook.postid = reply.postid set guestbook.dtlastreply = reply.replytimewhere [reply]. [PostId] = [Guestbook]. [postid]
Copy table Select * INTO B from A
Copying table INSERT INTO B (A, B, C) SELECT D, E, F from B
