将SQL过程转换为MYSQL过程 [英] Convert SQL Procedure to MYSQL procedure

问题描述

大家好，

请将此sql存储过程转换为Mysql存储过程.

Hi all,

Please convert this sql stored procedure to Mysql stored procedure.

CREATE PROC [dbo].[LoadData]
(
   @mode int=NULL,
   @id int=null
)
AS 
BEGIN

   IF(@mode=1)
      BEGIN
         IF(@id>0)
            BEGIN
               SELECT * FROM tbl_user Where pk_userid=@id and bActive=1
            END 
         ELSE
            BEGIN
               SELECT usr1.pk_userid, 
                      usr1.username, 
                      case usr1.roleid 
                         when 1 then 'Admin'
                         when 2 then 'User' 
                         when 3 then 'Sub User' 
                         WHEN 4 then 'Partner' 
                         else 'Super Admin' 
                      END as UserRole,
                      ISNULL(usr2.username,'') As Head 
               FROM tbl_user usr1 
               LEFT JOIN tbl_user usr2 ON usr1.headuserid=usr2.pk_userid
               WHERE usr1.bActive=1 AND usr1.roleid IN (1)
               --WHERE usr1.bActive=1 AND usr1.roleid NOT IN (5)
            END
         END
	
END

在此先感谢
Rajkumar

Thanks in advance
Rajkumar

推荐答案

尝试这些开源
mssql2mysql [ ^ ]
ms2my:从MSSQL到MySQL的转换器 [ ^ ]
从MSSQL到MySQL导出器 [

Try these opensources
mssql2mysql[^]
ms2my: MSSQL to MySQL converter[^]
MSSQL to MySQL Exporter[^]

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