how to join two fields

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi to all!

i create procedure in which i have two arguments

id and name

in table i have three fields
id , name, iname

where i will pass id and name to procedure and the
iname should be id+name

e.g.
id=23
name=asd
iname=asd123

Posted 3-Aug-11 19:29pm

kami124

Add a Solution

4 solutions

Solution 1

You can use +

SQL

Select id+name from tablename
update tablename set iname = id+name

If id is numeric then you should use Cast or Convert.

SQL

CONVERT(varchar, id) + name

Posted 3-Aug-11 19:35pm

Prerak Patel

Solution 2

Assuming your ID is INT, you can do it this way.

SQL

SELECT id, name, name + CONVERT(VARCHAR(10), id) AS iname FROM yourTable

Posted 3-Aug-11 19:40pm

walterhevedeich

Solution 3

Read more about stored procedures here[^].

Posted 3-Aug-11 19:40pm

Abhinav S

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)

Mahendra.p25 · Accepted Answer · 2011-08-03T19:44:00

Solution 4

i think you want to insert Data
for that try this

insert into TableName values(@id,@Name,cast(@id as varchar(50))+@Name)

Posted 3-Aug-11 19:44pm

Mahendra.p25

Comments

kami124 4-Aug-11 2:22am

thanks

kami124 4-Aug-11 2:55am

here is little problem
e.g id= 123
name=asdf
then
iname=123asdf
but i want like this
asdf123
how to do this

Mahendra.p25 4-Aug-11 6:21am

insert into TableName values(@id,@Name,@Name+cast(@id as varchar(50)))