头疼死了问题,毕业设计,急,急急,~!

Question

select 前面直接加 insert into tablename 就行了!
CREATE proc Scase
@r_number varchar(50)
as 
insert into tablename
select register.suffer_ID,sufferInfo.suffer_Name,sufferInfo.suffer_Age,
register.suffer_Number,register.suffer_Time,register.suffer_Office,
register.suffer_Ill,register.employee_Name
from register,sufferInfo
where register.suffer_ID=sufferInfo.suffer_ID
and register.suffer_Number=@r_number

Answer 1

楼上着位大哥,谢谢你,我可走了不少弯路..几乎什么怪想法我全做了。连直接.values着不可以完成的事,我全是了
真是一言惊醒梦中人~!