如何在ms sql server和我的sql中创建游标，如oracle [英] how to create cursor in ms sql server and my sql like oracle

问题描述

嗨..

如何在ms sql server和mysql中创建简单的游标如oracle，我知道在oracle下面就是例子

Hi..
how to create simple cursor in ms sql server and mysql like oracle,i know in oracle following is example

DECLARE
    CURSOR C IS SELECT * FROM tbinstrument;
BEGIN
    FOR CV IN C
    LOOP
        INSERT INTO tbnseinstrument VALUES(CV.ins_id,CV.ins_name);
    END LOOP;
END;
/

推荐答案

光标在其他系统中非常相似。在Sql Server中，查看 DECLARE CURSOR [ ^ ]



因此，您的游标定义如下所示：

The cursor is quite similar in other systems. In Sql Server, have a look at DECLARE CURSOR[^]

So your cursor definition would look something like:

DECLARE c CURSOR FOR SELECT * FROM tbinstrument;

在MySql中，看看游标DECLARE语法 [ ^ ]

这篇关于如何在ms sql server和我的sql中创建游标，如oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！