摘要:
alter proc updateStudent@id int,@id2 intasdeclare @SchoolID intdeclare @ClassID intdeclare @StudentID intdeclare @IDNumber intdeclare @IDAAA intbegindeclare FeeInsertStudent cursor forselect stuID,SchID,ClasID from T_School where ID=@idopen FeeInsertStudentfetch next from FeeInsertStudent into @Scho 阅读全文
摘要:
--创建数据库create proc InsertStudentas--定义所需要的变量declare @SchoolID intdeclare @ClassID intdeclare @StudentID intdeclare @IDNumber int --条件判断时需要begin--创建游标declare FeeInsertStudent cursor forselect stuID,SchID,ClasID from T_School--打开游标open FeeInsertStudent--从游标里取出数据给 变量 赋值fetch next from FeeInsertStudent 阅读全文