在sql server 2008存储过程中连接数字 [英] Join numbers in sql server 2008 stored procedure

问题描述

如何在sql server 2008中加入数字





例子

How do you join numbers in sql server 2008


example

SET @FIRSTNO= 400

SET @SECONDNO=12


SET @JOINNO= FIRSTNO+''+SECONDNO

expectation         =40012 

就是上面正确的方式





请建议



谢谢



< b>我尝试了什么：



我检查了自己的程序和互联网

（大喊大叫已删除）

is the above the right way


Please advice

Thanks

What I have tried:

I have checked my own programs and the internet
(shouting removed)

推荐答案

如果你想要一个字符串结果：

If you want a string result:

DECLARE @FIRSTNO INT
DECLARE @SECONDNO INT
DECLARE @JOINNO VARCHAR(MAX)
 
SET @FIRSTNO= 400
SET @SECONDNO=12

SET @JOINNO= CAST(@FIRSTNO AS NVARCHAR) + CAST (@SECONDNO AS NVARCHAR)

如果你想要一个整数：

If you want an integer:

DECLARE @FIRSTNO INT
DECLARE @SECONDNO INT
DECLARE @JOINNO INT
 
SET @FIRSTNO= 400
SET @SECONDNO=12

SET @JOINNO= CAST(CAST(@FIRSTNO AS NVARCHAR) + CAST (@SECONDNO AS NVARCHAR) AS INT)

如果它们是INT类型，那么你首先需要转换为VARCHAR（），否则它们将被添加（如在数学加法中）。例如：

If they are of INT type then you would want to convert to VARCHAR() first otherwise they will be added (as in Math addition). For example:

DECLARE @First INT, @Second INT
SELECT @First = 1, @Second = 2
SELECT CONVERT(VARCHAR(50), @First) + CONVERT(VARCHAR(50), @Second) 

或者你可以使用CONCAT（）

Or you could use CONCAT()

SELECT CONCAT(@First, @Second)

将它们转换为字符串。

which will convert them to strings for you.

这篇关于在sql server 2008存储过程中连接数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！