在sql server 里用sql语句如何复制多行记录呀

[chenhw_08]

在sql server 里用sql语句如何复制多行记录呀

[hecong875]

-- select * from Mst_Restaurants  
-- delete Mst_Restaurants
-- sp_help Mst_Restaurants
declare @Count int 
declare @OverCount int 
declare @DateType int 

select @Count = 1

select @DateType = 101

select @OverCount = 100000

while @Count < @OverCount 
Begin
   insert into Mst_LivingService
(
ProvinceNo,
CityNo,
ServerName,
BusinessesName,
BusChineseCode,
BranchName,
BranchChineseCode,
Aliases,
Phone,
Address,
MsgType,
AreaNo,
PostCode,
OwnedArea,
LandmarkBuilding,
PopularityIndex,
BusinessDescribe,
BusinessFeatures,
StartTime,
EndTime,
BusLines,
BusPath,
ParkingSpaces,
PrestigeValue,
blVISA,
AgreementDiscount,
blSingle,
blOrder,
ConsumeLevel,
Commend,
Area,
NumMaxRoom,
NumMaxTable,
NumMax,
NumRoom,
NumMinRoom,
VegetablesSeries,
Signboardsvegetables,
Remark,
Status,
LoginUser,
LoginTime,
UpdateUser,
UpdateTime,
TheirTradesNo
)
values
(
61000000,
61010000,
101,
'陕西第一碗餐饮',
'SXDYWCY',
'总店',
'ZD',
NULL,
'000-00000000|-*|',
'西安市莲湖区西二环40号',
1,
61010400,
0,
NULL,
NULL,
.0,
NULL,
NULL,
getDate(),
getdate(),
NULL,
NULL,
0,
0,
0,
.0,
0,
0,
0,
NULL,
0,
0,
0,
0,
0,
0,
NULL,
NULL,
NULL,
1,
1,
getdate(),
NULL,
NULL,
1

)
  select @DateType =@DateType+1 
  select @Count = @Count+1
-- if @DateType > 1
--  begin
--  select @DateType = 301
--  end
 
End

你可以看看

[chen_ya_ping]

先把要复制的数据选出来，然后再插入这个表中。

[zsuswy]

如楼上的
insert into 源table select * from 目标table where ........
或者
select into 目标table from 源table where ........

[中年秃头大叔]

例如：要把a表中符合条件的数据复制到b表中
insert into b select * from a where ..

例a表:id num
b表id num
insert into b select * from a where a.id<=5//where 语句可换成自己需要的。

[teerhu]

[Quote=引用 4 楼 zsuswy 的回复:]
如楼上的
insert into 源table select * from 目标table where ........
或者
select into 目标table from 源table where ........
[/Quote]
支持

[xk35860368qqqq]

[Quote=引用 1 楼 hecong875 的回复:]
SQL code
-- select * from Mst_Restaurants
-- delete Mst_Restaurants
-- sp_help Mst_Restaurants
declare @Count int
declare @OverCount int
declare @DateType int

select @Count = 1

select @DateType = 101

select @OverCount = 100000

while @Count < @OverCount
Begin
insert into Mst_LivingService
(
ProvinceNo,
CityNo,
ServerName,
BusinessesName,
BusChineseCode,
BranchN…
[/Quote]

注解都没有要楼主他正麽看啊 ·~

[步慢生错]

其实很简单嘛
insert into 目标表(列名) select 列名 from 源表 where xxxx