SQL´´½¨Êý¾Ý¿â¡¢±í¡¢´æ´¢¹ý³Ì¼°µ÷ÓÃ

--Èç¹û´æÔÚÊý¾Ý¿âprogrammerPay  ¾Íɾ³ý
if exists (select * from sysdatabases where name='programmerPay')
drop database programmerPay
go
--´´½¨Êý¾Ý¿âprogrammerPay
create database programmerPay
on primary
(
name ='programmerPay_data',
filename='D:\programmerPay\programmerPay_data.mdf',
maxsize=3mb,
filegrowth=15%
)
log on
(
name ='programmerPay_log',
filename='D:\programmerPay\programmerPay_log.ldf',
maxsize=1mb,
filegrowth=15%
)
go
use programmerPay
go
--´´½¨±íprowage
create table prowage
(
id int identity(1,1) not null,--Ö÷¼ü ±êʶÁÐ
Pname char(10) not null,--³ÌÐòÔ±ÐÕÃû
wage  int  not null--³ÌÐòÔ±¹¤×Ê
)
go
--Ϊ±íprowage id ×Ö¶ÎÌí¼ÓÖ÷¼üÔ¼Êø
alter table prowage
add constraint PK_id primary key(id)
--²åÈë²âÊÔÊý¾Ý
insert into prowage (pname,wage)
values ('ÕÅÈý',5000)
insert into prowage (pname,wage)
values ('ÀîËÄ',1200)
insert into prowage (pname,wage)
values ('¶þÔÂ',1700)
insert into prowage (pname,wage)
values ('À¶Ìì',5700)
insert into prowage (pname,wage)
values ('Ñô¹â',8700)
insert into prowage (pname,wage)
values ('ÉñÖÝ',1100)
insert into prowage (pname,wage)
values ('Ôø¾­²Ø',1300)
insert into prowage (pname,wage)
values ('ruo',1200)
insert into prowage (pname,wage)
values ('chend',1400)
--Èç¹û´æÔÚ´æ´¢¹ý³Ìproc_addWage1  ¾Íɾ³ý
if exists (select * from sysobjects where name='proc_addWage1')
drop procedure proc_addWage1
go
--´´½¨´æ´¢¹ý³Ìproc_addWage1
create procedure proc_addWage1
as
set nocount on
declare @firstwage  int
select @firstwage=sum(wage) from prowage
while (1=1)
    begin
          declare @notpass int, @count int--¶¨ÒåÁ½¸ö±äÁ¿ û´ïµ½2200µÄÈËÊýºÍ×ÜÈËÊý
          select @notpass=count(*) from prowage where wage<2200
          select @count =count(*) from prowage
       if(@notpass*