MsSql 2000存储过程转换为MySql过程 [英] MsSql 2000 Stored Procedure convert to MySql Procedure

问题描述

创建以下存储过程以与C＃2005一起使用。现在，我想将此过程转换为MySQL / C＃。



请帮我改为与C＃2005一起使用。

The following Stored procedure created to use with C# 2005. Now, I would like to convert this procedure to MySQL / C#.

Please help me to change to use with the C# 2005.

CREATE PROCEDURE AUTOGENERATEBILLNUMBER 
(
@ACCYEAR INT
)
AS	
BEGIN
	DECLARE @COUNT INT
	DECLARE @BILLNUMBER INT
	DECLARE @MAXBILLNUMBER INT
	DECLARE @LENGTH INT

	SELECT @MAXBILLNUMBER  = MAX(BILL_NO) FROM BILLS WHERE ACC_YEAR = @ACCYEAR
	IF(@MAXBILLNUMBER IS NULL)
	BEGIN
	SET @MAXBILLNUMBER = 1
	
	END

	ELSE
	BEGIN
	SET @MAXBILLNUMBER = @MAXBILLNUMBER + 1
	
	END
	INSERT INTO BILLS (BILL_NO,ACC_YEAR) VALUES (@MAXBILLNUMBER,@ACCYEAR)
END
GO

推荐答案

几个工具 - http://convert.software.informer.com/download-convert-sql-server-stored-procedures-to-mysql/ [< a href =http://convert.software.informer.com/download-convert-sql-server-stored-procedures-to-mysql/target =_ blanktitle =New Window> ^ ]

http://www.ispirer.com/products/mysql-migration [ ^ ]



搜索，您可以找到更多链接。

Couple of tools - http://convert.software.informer.com/download-convert-sql-server-stored-procedures-to-mysql/[^]
http://www.ispirer.com/products/mysql-migration[^]

Search and you may find some more links.

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