ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

table1 
 id  
 01 
 02
...
table2 

 id registerdate
 01 2010-02-27 22:49:26.633

 02 2010-02-27 22:56:23.070

...
ÔÚtable1ÖÐÐÂÔöregdate ÁÐ
²¢°ÑregisterdateÁеÄÖµ²åÈë regdateÁÐÖÐ

---

SQL code:
--truncate table table1 --ɾ³ýtable1

select *
into table1
from table2



ÕâÑùÊDz»ÊǸü¿ì£¿

---

SQL code:

alter table table1 add regdate datetime
update table1 set regdate=registerdate from table2 where table2.id=table1.id

---

SQL code:
exec ('alter table table1 add regdate datetime')
exec ('update table1 set regdate=registerdate from table2 where table2.id=table1.id')

---

ÒýÓÃ

SQL code
--truncate table table1 --ɾ³ýtable1

select *
into table1
from table2



ÕâÑùÊDz»ÊǸü¿ì£¿

»¹ÓкܶàÁÐûЩ³öÀ´µÄ¡£¡£¡£

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/