Convert form bigint to nvarchar

Question

0.00/5 (No votes)

See more:

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

Posted 18-Jul-13 21:22pm

Mare7

Updated 18-Jul-13 21:47pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jaideepsinh · Accepted Answer · 2013-07-18T21:35:00

Solution 1

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

Posted 18-Jul-13 21:35pm

jaideepsinh

Comments

Mare7 19-Jul-13 3:45am

I write ur solution in my stored procedure. however the line turns to error which said "A select statement that assigns a value to a variable must not be combined with data retrieval operations. and when i execute it, its throwing an error such as Incorrect syntax near '='.

Mare7 19-Jul-13 5:18am

Owh..juz need to change the position only. Tq for responding to my question..i appreciate it a lot. thx again

jaideepsinh 19-Jul-13 5:25am

Can you please accept as answer and vote.

berrymaria · Accepted Answer · 2013-07-18T21:40:00

Solution 2

SQL

SELECT @CmpntID = CAST(ComplaintID AS BIGINT)

Posted 18-Jul-13 21:40pm

berrymaria

Updated 18-Jul-13 21:41pm

v2

Comments

Mare7 19-Jul-13 5:01am

Hi,thx chicam. i change it a little and it works great. thx a lot.
here is what i do --> SELECT @CmpntID = CAST(CmpntID AS VARCHAR)

berrymaria 19-Jul-13 5:12am

Oh! I just thought you need to assign and cast ComplaintID to bigInt, but then it was the CompntID to be Varchar. Can you accept my answer? :)

Mare7 19-Jul-13 5:16am

Of Course. Thx again..

berrymaria 19-Jul-13 5:28am

You're welcome :) and Thank you too! :)