各种关于SQL的程序编程，存储过程，触发器，三级模式、动静态游标



declare cursor2 cursor static

for

select * from student

go

open

cursor2

go

fetch first from cursor2

update student

set sage=sage+1

where sno= 0001 -On the various programming SQL, stored procedures, triggers, three modes, static and dynamic cursor declare cursor2 cursor static for select* from student go open cursor2 go fetch first from cursor2 update student set sage = sage+1 where sno = ' 0001 '