求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



这样是不是更快？

---

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



这样是不是更快？

还有很多列没些出来的。。。

---

SQL code

---

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