SQL存储过程实例.doc

--1、创建存储过程--ifexists(select*fromsysobjectswherename='Sum_wage')dropprocedureSum_wageGOcreateprocedureSum_wage@PWageint,@AWageint,@totalintaswhile(1=1)beginif(selectcount(*)fromProWage)>2*(selectcount(*)fromProWagewhereWage>=@PWage)updateProWageset@total=@total+@AWage,Wage=Wage