how to declare variable in select statement

Question

User2014201474 posted

I have the following code use in sql server

strSql = "DECLARE @SeqNo Integer "

strSql += "SELECT @SeqNo = MAX(SeqNo) FROM tblPromotion "
strSql += "SET @SeqNo = ISNULL(@SeqNo,0) "
strSql += "SET @SeqNo = @SeqNo + 1 "

strSql += "INSERT INTO tblAdvertisement(SeqNo) Values (@SeqNo)";

Can anyone tell me in my sql how to declare a variable

Answer 1

User151513110 posted

Hi, 

ying7690,

check this link: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug598.htm.

http://msdn.microsoft.com/en-us/library/aa258839(v=sql.80).aspx

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/40957;pt=38523/*

Mark as Answer if its help.

Answer 2

User2014201474 posted

(SELECT SeqNo FROM(SELECT CASE WHEN MAX(SeqNo) IS NULL THEN 0 Else SeqNo + 1 END AS SeqNo FROM tblmessage) AS SeqN)

Answer 3

User151513110 posted

Hi ying7690,

You can use third party tool regarding convert sql server query to mysql query

following tool available you can download and use it.

http://www.swissql.com/products/sql-translator/sql-converter.html

http://convert-sql.qarchive.org/

Mark as answer if its help.