＋设为首页 ＋添加到收藏夹
CREATE PROCEDURE [pro_ssfzsp_spstroe]
AS
set nocount on
declare @li_spbhid int
declare @li_spckid int
declare @li_spcwid int
declare @li_spjs int
declare @ld_spsl decimal(12,2)
delete ssfzsp_spstore
declare cursor_ckcwstore scroll cursor for
select spbhid,spckid,spcwid,spjs,spsl from ssfzvw_spdxmx
open cursor_ckcwstore
fetch first from cursor_ckcwstore
into @li_spbhid,@li_spckid,@li_spcwid,@li_spjs,@ld_spsl
while @@fetch_status = 0
begin
insert into ssfzsp_spstore(spbhid,spckid,spcwid,spjs,spsl)
values(@li_spbhid,@li_spckid,@li_spcwid,@li_spjs,@ld_spsl)
fetch next from cursor_ckcwstore
into @li_spbhid,@li_spckid,@li_spcwid,@li_spjs,@ld_spsl
end
close cursor_ckcwstore
deallocate cursor_ckcwstore
commit;
return
GO
有必要用游标吗
insert into ssfzsp_spstore(spbhid,spckid,spcwid,spjs,spsl)
select spbhid,spckid,spcwid,spjs,spsl from ssfzvw_spdxmx
