将表格bigint转换为nvarchar [英] Convert form bigint to nvarchar

问题描述

大家好，有没有人可以教我如何在存储过程中将bigint转换为nvarchar。



以下是我的数据库中的一些相关字段：



表A

CmpntID bigint



表B

ComplaintID nvarchar50



我想将表A中的CmpntID数据插入表B中的ComplaintID字段



查询是这样的:(已经声明@CmpntID）





SELECT @CmpntID = CmpntID< - 这里我应该正确转换它，但我不知道

FROM TABLE A WHERE CmpntID = @CntntID

解决方案

声明@CmpntID BigINT

SELECT CAST（@CmpntID AS VARCHAR）=来自TableA的CmpntID

  SELECT  < span class =code-sdkkeyword> @ CmpntID  = CAST（ComplaintID  AS   BIGINT ） 

Hi, can anyone teach me how to convert from bigint to nvarchar in stored procedure.

Here are some field related in my db:

Table A
CmpntID bigint

Table B
ComplaintID nvarchar50

I wanna insert the data of CmpntID in Table A to ComplaintID field in Table B

the query goes like this : (Already declare @ CmpntID)


SELECT @CmpntID = CmpntID <--here i should convert it right, but i don't know how
FROM TABLE A WHERE CmpntID = @CmpntID

解决方案

declare @CmpntID BigINT
SELECT CAST(@CmpntID AS VARCHAR) = CmpntID from TableA

SELECT @CmpntID = CAST(ComplaintID AS BIGINT)

这篇关于将表格bigint转换为nvarchar的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！