create proc copydata
as
begin
set nocount on

declare @id bigint,@name varchar(50),@level varchar(10)
declare id_cursor cursor for
select [id],[name],[type] from [user] order by regtime

open id_cursor

fetch next from id_cursor into @id,@name,@level
while @@fetch_status=0
begin
insert into [draws_bonus](u_id,u_name,u_level) values(@id,@name,@level)
fetch next from id_cursor into @id,@name,@level
end
close id_cursor
DEALLOCATE id_cursor
set nocount off
select * from [draws_bonus]
end

能不能用一条语句实现两表之间的数据复制 ？
哎...已经解决..
insert into [draws_bonus](u_id,u_name,u_level) select [id],[name],[type] from [user]
老忘这种方式

[此贴子已经被作者于2007-4-7 0:49:20编辑过]