SQL statement table related updates

The topic is as follows:

Table1There areID, dateTwo Fields

Table 2There areID, dateTwo Fields

WhenTable1OfDateAndTable 2OfDateEquivalentTable 2OfIDThe value is updatedTable1OfIDGo.

Answer:
Update Table1 Set ID = B. ID from table 1 , Table2 B where a. Data = B. Data

 
In addition, batch insert sentence:
Insert into Table1 (date) (select date from table2)

Batch Update time table fields
Update time set the_year = year (the_date), the_month = month (the_date ),
The_quarter = datepart (QQ, the_date), the_week = datepart (wk, the_date), the_day = Day (the_date)