如何在SQLServer中将三个数字值与Lage数据连接 [英] How to concatenate Three Numeric values with lage data in sqlserver

问题描述

大家好，我有三个琴弦

a = 1010111111111111;

b = 10011110000011111000011111111;

c = 111111100011111111111111


如果连接这些值，我会得到错误.

如何在sqlserver中连接这些值.

帮助我

Hi guys , i have three strings

a=1010111111111111;

b=10011110000011111000011111111;

c=111111100011111111111111


If concatenate those values i got the errors.

How to concatenate those values in sqlserver.

help me

推荐答案

select convert(varchar,1010111111111111) + convert(varchar,10011110000011111000011111111) + convert(varchar,111111100011111111111111)
select convert(varchar,1010111111111111) + ',' + convert(varchar,10011110000011111000011111111) + ',' + convert(varchar,111111100011111111111111)

--OR--

select convert(varchar,a) + convert(varchar,b) + convert(varchar,c) From YourTable
select convert(varchar,a) + ',' + convert(varchar,b) + ',' + convert(varchar,c) From YourTable

祝您编码愉快！
:)

Happy Coding!
:)

这篇关于如何在SQLServer中将三个数字值与Lage数据连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！