22,300
社区成员




declare @col1 varchar(50)
declare cursor1 cursor for
select col1 from tb
open cursor1
fetch next from cursor1 into @col1
while @@fetch_status=0
begin
if @col1='a' exec sp1
else if @col1='b' exec sp2
else if @col1='c' exec sp3
else if @col1='d' exec sp4
else exec sp5
fetch next from cursor1 into @col1
end
close cursor1
deallocate cursor1
declare @ID_ChipSize BIGINT
declare cursor1 cursor for select ID_ChipSize from ChipSize where MTWID > 0
open cursor1
fetch next from cursor1 into @ID_ChipSize
while @@fetch_status=0
BEGIN
print @ID_ChipSize
EXEC [1A_CalMainChipSize] @ID_ChipSize -- 调用SP实现不同计算
fetch next from cursor1 into @ID_ChipSize
END
close cursor1
deallocate cursor1