怎样建变量放入临时表中
如下所示：
R是一张原本就有的表，有如下字段：idno(主键)、name、sex、age、grade
Create #Temp
(
idtep int
nametep nvarchar(30)
gradetep numeric(4,2)
)
Declare @name nvarchar(30)
Declare @id int
Declare @grade numeric(4,2)
Declare my_cursor Cursor Scroll for
select * from R
open my_cursor
While @@fetch_status = 0
begin
select id,name,grade from R where sex = '额'
fetch next from my_cursro into @name,@id,@grade
end
close my_cursor
deallocate my_cursor
