t-SQL 急求解决:关于SQLSERVER的表复制的问题！！！！

Question

Create table tb_temp(Name varchar(24)not null,Address varchar(50),Tel varchar(24),[Desc] varchar(500),Create_Month varchar(24) not null,Create_Year varchar(24) not null)Create table tb_Offc(Id int identity(1,1)not null,Name varchar(24)not null,Address varchar(50),Tel varchar(24),[Desc] varchar(500))
insert into tb_Offc([name],Address,Tel)
select 'Eva Xia','China.shanghai','021-54781478 '
union all
select 'Sabrina', 'Gu USA',                     '562-010-141-8796'
union all
select 'Tank Zhou', 'China.guangzhou',     '15978458871' insert into tb_temp(Name, Address, Tel, [Desc], Create_Month, Create_Year)
select name,Address,Tel,[Desc],month(getdate()),year(getdate())
from tb_Offcselect * from tb_tempName                     Address                                            Tel                      Desc                                                                                                                                                                                                                                                             Create_Month             Create_Year
------------------------ -------------------------------------------------- ------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------ ------------------------
Eva Xia                  China.shanghai                                     021-54781478             NULL                                                                                                                                                                                                                                                             4                        2009
Sabrina                  Gu USA                                             562-010-141-8796         NULL                                                                                                                                                                                                                                                             4                        2009
Tank Zhou                China.guangzhou                                    15978458871              NULL                                                                                                                                                                                                                                                             4                        2009(3 row(s) affected)

Answer 1

Create table tb_temp
(Name varchar(24)not null,
Address varchar(50),Tel varchar(24),
Descr varchar(500),
Create_Month int not null,
Create_Year int not null)Create table tb_Offc
(Id int identity(1,1)not null,
Name varchar(24)not null,
Address varchar(50),
Tel varchar(24),
Descr varchar(500))insert into tb_Offc(name,Address,Tel,Descr)
select 'Eva Xia',         'China.shanghai',             '021-54781478','' union all 
select 'Sabrina Gu', 'USA',                     '562-010-141-8796','' union all 
select 'Tank Zhou', 'China.guangzhou',     '15978458871','' insert into tb_temp
--(Name,Address,Tel,Descr,Create_Month,Create_Year)
select m.name,m.address,m.Tel,m.descr,month(getdate()),year(getdate())
from tb_Offc mselect * from tb_Offc
select * from tb_tempdrop table tb_Offc
drop table tb_temp

Answer 2

这样子会在tb_temp表的后面新增加两个字段的，而不是把那个插入到对应的列。

Answer 3

你可不可以帮我看一段存储过程。我发个email给你，代码有点长，我总是出不来您写的那种效果。

Answer 4

是不是如果其中tb_temp在存储过程中动态创建的就有有问题呀？可以一次插入一条数据的吗？

Answer 5

加MSN吧,跟我的邮箱一样你的程序问题还不少.

Answer 6

你在线吗？
我的不是msn,需要你是在线的状态才能发消息