将我的sql过程转换为sql server [英] converting my sql procedure to sql server

问题描述

您好朋友，这是一个在temp表中复制表数据的mysql程序.我在mysql中没有工作.请您帮我将其转换为sql server程序
提前感谢朋友.

hello friends ,this is a mysql procedure to copy a table data in temp table .I have not work in mysql.Can yuo please help me in converting it to sql server procedure
.Thanks in advance freinds.

CREATE  PROCEDURE sp_category_select3()
as BEGIN
declare done int default 0
declare categoryid int
declare categoryname varchar(100)
declare groupunderid int
declare groupundername varchar(50)
declare alias varchar(100)
declare supercategory varchar(100)
declare NotZero int default 0
declare cur1 cursor for select c.lcategoryid, c.ccategoryname, c.lundercategoryid,
 c.calias, s.csupercategoryname from category c inner join supercategory s on
  c.lsupercategoryid=s.lsupercategoryid where c.bdeleteflag=0
declare continue handler for not found set done = 1
drop table if exists temptablecategory
create temporary table temptablecategory(cat_id int, cat_name varchar(100), 
cat_underid int, cat_under_group varchar(100), cat_alias varchar(100), cat_super varchar(100))
open cur1
  repeat
    fetch cur1 into categoryid, categoryname, groupunderid, alias, supercategory
    set groupundername=""
        if not done Begin
       if groupunderid=0  Begin
            set groupundername=""
                   	       
       	 elseif groupunderid<>0 Begin
           set groupundername=(select distinct c.ccategoryname as undercategoryname from category as c inner join category as d on c.lcategoryid=d.lundercategoryid where d.lundercategoryid=groupunderid and c.bdeleteflag=0) 
                
         End  
        insert into temptablecategory values(categoryid, categoryname, groupunderid,groupundername, alias, supercategory)
          End
  until done end repeat
	
   close cur1
 select * from temptablecategory drop table temptablecategory
    END */$$
 
Go

推荐答案

转到

语法对于MySQL而言并没有太大不同.您的代码使用cursor&您可以检查以下代码作为MySQL中游标的参考:

http://www.java2s.com/Tutorial/MySQL/0240__Cursor/Usingwhilelooptoloopthroughacursor.htm [ ^ ]

the syntax is not very different for MySQL. your code uses cursor& you can check the following code as a reference for cursors in MySQL:

http://www.java2s.com/Tutorial/MySQL/0240__Cursor/Usingwhilelooptoloopthroughacursor.htm[^]

这篇关于将我的sql过程转换为sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！