begin INSERT INTO IP_Subject(stId,sName,sIndex,sState,sRevalue, sReturnState,sAddTime,sEndTime,sOPUid,sPic,sText,sNote1,sNote2) VALUES(@stId,@sName,@sIndex,@sState,@sRevalue,@sReturnState,getdate(), getdate(),@sOPUid,@sPic,@sText,@sNote1,@sNote2) DECLARE @length int --長(zhǎng)度 DECLARE @next int --標(biāo)量 DECLARE @did int --地區(qū)id DECLARE @sId1 int --獲取插入的id SET @sId1=@@IDENTITY SET @next=0 SELECT @length=COUNT(*) FROM IP_CityCountry --獲取長(zhǎng)度 WHILE(@next<@length) BEGIN SELECT TOP 1 @did=ccId FROM IP_CityCountry WHERE ccId NOT IN (SELECT TOP (@next) ccId FROM IP_CityCountry) INSERT INTO IP_District_Sub_Relation(dId,sId,usrCustomID,usrState,usrRebate) VALUES(@dId,@sId1,0,0,@sRevalue) --exec MS_InsertIP_Subject 2,'修改密碼',19,1,0.00,21,0,'','','','',0,0 SET @next=@next+1 END SELECT @sId1 END ?這是我寫的一個(gè)循環(huán)插入的存儲(chǔ)過程。發(fā)現(xiàn)，執(zhí)行的時(shí)候效率很慢。求高手指點(diǎn)，提高其效率！</p>