--創(chuàng)建數(shù)據(jù)庫(kù)

create proc InsertStudent

as

--定義所需要的變量

declare @SchoolID int
declare @ClassID int
declare @StudentID int
declare @IDNumber int ?--條件判斷時(shí)需要

begin

--創(chuàng)建游標(biāo)

declare FeeInsertStudent cursor for?
select stuID,SchID,ClasID from T_School?

--打開(kāi)游標(biāo)

open FeeInsertStudent?

--從游標(biāo)里取出數(shù)據(jù)給 變量 賦值

fetch next from FeeInsertStudent into @SchoolID,@ClassID,@StudentID

--判斷有標(biāo)的狀態(tài)

while @@FETCH_STATUS=0

begin

--為變量賦值

set @IDNumber=(select count(*) from T_LeaveSchool where StudentID=@StudentID and SchoolID=@SchoolID and ClassId=@ClassID)
if(@IDNumber=0) ?--判斷
begin
insert into T_LeaveSchool(StudentID,ClassID,SchoolID)
values( @StudentID,@ClassID,@StudentID)
end
fetch ?next from FeeInsertStudent into @SchoolID,@ClassID,@StudentID
end
close FeeInsertStudent ? ? ? ? --關(guān)閉游標(biāo)
deallocate FeeInsertStudent ? ? ? ? ? ? ? ? --撤銷游標(biāo)


end

簡(jiǎn)單使用游標(biāo)插入數(shù)據(jù)