--創建數據庫

create proc InsertStudent

as

--定義所需要的變量

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

begin

--創建游標

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

--打開游標

open FeeInsertStudent?

--從游標里取出數據給 變量 賦值

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

--判斷有標的狀態

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 ? ? ? ? --關閉游標
deallocate FeeInsertStudent ? ? ? ? ? ? ? ? --撤銷游標


end

簡單使用游標插入數據