如何在SQL的单个列中连接两个不同的数据类型列 [英] How to join two different data type column in a single column in SQL

问题描述

我的查询就像

my query is like

select Customer_Details.ID+''''+Customer_Details.FirstName as UID from Customer_Details

但是ID是int类型，而FirstName是varchar类型.
所以我得到一个错误

But ID is int type and FirstName is varchar type.
so i get an error

报价:

将nvarchar值"ABC"转换为数据类型int时转换失败

Conversion failed when converting the nvarchar value ''ABC'' to data type int

推荐答案

select CAST(Customer_Details.ID AS NVARCHAR(255)) +''+Customer_Details.FirstName as UID from Customer_Details

希望这会有所帮助，然后接受并投票回答
--Rahul D.

Hope this helps if yes then accept and vote the answer
--Rahul D.

这篇关于如何在SQL的单个列中连接两个不同的数据类型列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！