select * from table into #temp 是将所有纪录添加到临时表,我是指把当前一条纪录添加到临时表
insert into #temp select * from table1 where ....
当前一条记录?这是指什么???如果是用游标,当然具有‘当前记录’一说,用法为: 假设游标当前记录值为:@field1,@field2,@field3,..... 那么,可以 insert into #temp_table values(@field1,@field2,@field3,.....)
好办,首先建立临时表: CREATE TABLE #mytemptb(col1 int,col2 char(10)) declare @i_fld1 int declare @c_fld2 char(10) declare mycursor cursor for select fld1,fld2 from mytable open mycursor while @@fetch_status=0 begin fetch mycursor into @i_fld1,@c_fld2 insert into #mytemptb(col1,col2) values(@i_fld1,@c_fld2) .......... end
insert into #tmp select * from table1
假设游标当前记录值为:@field1,@field2,@field3,.....
那么,可以
insert into #temp_table values(@field1,@field2,@field3,.....)
CREATE TABLE #mytemptb(col1 int,col2 char(10))
declare @i_fld1 int
declare @c_fld2 char(10)
declare mycursor cursor for select fld1,fld2 from mytable
open mycursor
while @@fetch_status=0
begin
fetch mycursor into @i_fld1,@c_fld2
insert into #mytemptb(col1,col2) values(@i_fld1,@c_fld2)
..........
end