SQL Server Must declare a scalar variable

cyvaqqii 于 2023-08-02 发布在 Scala

关注(0)|答案(1)|浏览(197)

I was creating a column that will give a me random number but I was getting some errors.

CREATE TABLE tblBookInfo
(
AccessionNumber NVARCHAR(MAX)
 RandomNumber NVARCHAR(10);
 AccNo NVARCHAR(MAX)
 @Upper INT;
 @Lower INT

SET @Lower = 1
SET @Upper = 9999

Select @RandomNumber = Round (((@Upper - @Lower -1)* RAND() + @Lower), 0)

SET @AccNo = 'LIBBOOKS' + RandomNumber
SELECT @AccNo

Set AccessionNumber = AccNo
)

ERRORS:

Incorrect syntax near 'RandomNumber'.
Must declare the scalar variable "@Lower".
Must declare the scalar variable "@Upper".
Must declare the scalar variable "@Upper".
Must declare the scalar variable "@AccNo".
Must declare the scalar variable "@AccNo".

tHank you for your help :D

sql-server

来源：https://stackoverflow.com/questions/14294539/must-declare-a-scalar-variable

1条答案

按热度按时间

xpcnnkqh1#

Its not very clear what you are trying to accomplish, but here is my interpretation of your code in the correct T-SQL syntax. I'm not prepared to guess what you're trying to do below that.

CREATE TABLE tblBookInfo 
(   
    AccessionNumber NVARCHAR(MAX),
    RandomNumber NVARCHAR(10), 
    AccNo NVARCHAR(MAX) 
)
DECLARE @Upper          INT, 
        @Lower          INT,
        @RandomNumber   INT

SET @Lower = 1 SET @Upper = 9999

SELECT @RandomNumber = Round (((@Upper - @Lower -1)* RAND() + @Lower), 0)

SELECT @RandomNumber

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server Must declare a scalar variable

1条答案

相关问题

热门标签

最新问答