三级久色I久久AV电影院I激情图区I一级久I国产一区爱视频I国产亚州未满十八I天堂8在线19I欧美激情a∨在线视频播放I中文字幕黄色I一级特黄高清I亚洲无码人妻I五月婷婷六月丁香激情I亚洲AV免费电影I9一区二区I久久久国产一区二区I一级国产免费I99精品99I日本三级少妇

1.增加存儲(chǔ)過程

create  PROCEDURE [dbo].[GetQiangJianTJ]     @QiJRQ varchar(10),      @JieSRQ varchar(10) AS BEGIN     SET NOCOUNT ON;   --生成預(yù)約情況統(tǒng)計(jì)臨時(shí)表     Create table #tmp01(     序號(hào) int identity,     器具名稱 varchar(40),     數(shù)量 int     )     declare @QiJBH varchar(30),@QiJMC varchar(200),@QiJSL int,@QiJZSL int ,@QiJMC1 varchar(200)     set @QiJSL=0      set @QiJZSL=0          --定義主游標(biāo)     declare cur_Tongj cursor for     select QiJBH,QiJMC from QiJDM          open cur_Tongj     fetch next from cur_Tongj into @QiJBH,@QiJMC     while @@fetch_status=0     --select @QiJMC1=@QiJMC     begin     select @QiJMC1 =@QiJMC          select @QiJSL=count(@QiJBH) from V_WeiTQJ where QiJBH=@QiJBH and ShouLRQ>=@QiJRQ      and ShouLRQ<=@JieSRQ and WeiTFS like'%e-CQS系統(tǒng)網(wǎng)上預(yù)約%'          select    @QiJZSL=@QiJZSL+@QiJSL     if   exists (select @QiJBH from V_WeiTQJ where QiJBH=@QiJBH and ShouLRQ>=@QiJRQ      and ShouLRQ<=@JieSRQ and WeiTFS like'%e-CQS系統(tǒng)網(wǎng)上預(yù)約%')     begin     insert into #tmp01(器具名稱,數(shù)量)             values(@QiJMC,@QiJSL)     end                 fetch next from cur_Tongj into @QiJBH,@QiJMC     end     close cur_Tongj     deallocate cur_Tongj     insert into #tmp01(器具名稱,數(shù)量)             values('總計(jì)：',@QiJZSL)     select *  from #tmp01     drop table #tmp01     END

2.系統(tǒng)參數(shù)設(shè)置進(jìn)行對(duì)照