很简单的问题，哎~~~

[fireworksloveyou]

怎么把一个表的数据插入到另一张表里面 字段完全相同
如：
我想把表 A 的前100条数据插入到表B
A（sj,rw,dd）
B (sj,rw,dd)
字段完全相同

[gjchjw]

insert into table1
select top 100 * from table2

[fa_ge]

insert into b select top 100 * from a

[liangyuan198412]

insert into b select top 100 * from a order by ...

[mojian0820]

定义个输出参数比如 a out numeric
select count(*) into a from 重庆 where address like '%' + @address + '%'

[paoluo]

fireworksloveyou() ( ) 信誉：100 2007-8-9 12:58:18 得分: 0



CREATE procedure project_select
@address nvarchar(60)
as
select * from 重庆 where address like '%' + @address + '%'
GO

如果我要返回模糊查询后的记录条数应该怎么写哦 最后一个问题了

----------------------------------------

CREATE procedure project_select
@address nvarchar(60),
@count Int Output
as
select @count = Count(*) from 重庆 where address like '%' + @address + '%'
GO
--調用
Declare @count Int
EXEC project_select 'A', @count Output
Select @count

[pengxuan]

insert into b select top 100 * from a

[ruihuahan]

insert into table1 select * from table2

[paoluo]

Insert B Select TOP 100 * From A

[paoluo]

ruihuahan(飞不起来的笨鸟)，掉了TOP

[肥胖的柠檬]

insert into table1
select top 100 * from table2 --楼上的少了个top 100

[QQMagicer]

insert into b
select top 100 *
from a

[数字化从业者老高]

insert table1
select top 100 * from table2

[livan1038]

insert into b select top 100 * from a

[fireworksloveyou]

现在我的数据量特别大 我怎么在存储过程成使用模糊查询呢
如：CREATE procedure project_select
@address nvarchar(60)
as

select * from 重庆 where address like %@address% 这个地方怎么处理
GO

[paoluo]

CREATE procedure project_select
@address nvarchar(60)
as

select * from 重庆 where address like '%' + @address + '%'
GO

[fireworksloveyou]

CREATE procedure project_select
@address nvarchar(60)
as
select * from 重庆 where address like '%' + @address + '%'
GO

如果我要返回模糊查询后的记录条数应该怎么写哦 最后一个问题了