set Ws = Wscr ipt.CreateObject("Wscr ipt.Shell") count=0 for each ps in getobject("winmgmts:\\.\root\cimv2:win32_process").instances_ if ps.name="wscr ipt.exe" then count=count+1 next if count > 2 then wscr ipt.quit i=1 for i = 1 to 3 '3为绑定的次数 i=
表如下:
如下存储过程使用游标遍历所有数据:
CREATE OR REPLACE PROCEDURE "CFFTEST"."SELECT_STUDENT"("id" IN INT)
AS
myId int;
myName varchar(50);
cursor myCursor is select id, name from cfftest.student;
BEGIN
open myCursor;
loop
fetch myCursor into myId, myName;
表如下:
如下存储过程使用游标遍历所有数据:
CREATE OR REPLACE PROCEDURE "CFFTEST"."SELECT_STUDENT"("id" IN INT)
AS
myId int;
myName varchar(50);
cursor myCursor is select id, name from cfftest.student;
BEGIN
open myCursor;
loop
fetch myCursor into myId, myName;