HOW TO CONCAT TABLE NAME WITH STRING ?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

HELLO ,

HOW TO CONCAT STRING WITH TABLE NAME

LIKE..

SQL

SELECT

     User_Master.UserCode + 'EmailAddressInfo'

FROM User_Master

EmailAddressInfo Is a String

Posted 14-Nov-14 23:00pm

Ankit Patel(AP)

Updated 14-Nov-14 23:08pm

King Fisher

v3

Add a Solution

Comments

King Fisher 15-Nov-14 5:09am

with table Name Mean? how do u expect your Result ?

Maciej Los 15-Nov-14 5:37am

Do not SHOUT!
Not sure what you want, but i'm almost sure you want to fetch data from table together with some text...

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)

DamithSL · Answer 1 · 2014-11-14T23:08:00

Solution 1

build your sql statement first and then execute it.

SQL

DECLARE @execquery AS NVARCHAR(MAX)
SET @execquery = N'SELECT User_Master.UserCode' + 'EmailAddressInfo' +' FROM User_Master'
EXEC(@execquery)

Posted 14-Nov-14 23:08pm

DamithSL

Comments

Manas Bhardwaj 15-Nov-14 5:42am

Yes, +5!

Maciej Los · Answer 2 · 2014-11-14T23:41:00

Solution 2

Please, read my comment to the question.

I'd suggest to read this: T-SQL: + (String Concatenation)[^]

If UserCode field returns numeric values, you need to convert it to a varchar data type:

SQL

SELECT  CONVERT(VARCHAR(30), UserCode) + 'EmailAddressInfo' AS NewFieldName
FROM User_Master

Posted 14-Nov-14 23:41pm

Maciej Los

Comments

Manas Bhardwaj 15-Nov-14 5:42am

Yes, +5!

Maciej Los 15-Nov-14 5:44am

Thank you, Manas ;)

King Fisher 15-Nov-14 5:45am

i don't understand the Question .did u? :)

Maciej Los 15-Nov-14 5:55am

As i mentioned in comment to the question, i'm not sure what OP wants to achieve, i can only guess...

King Fisher 15-Nov-14 6:07am

ha ha ha :)

Ankit Patel(AP) 15-Nov-14 6:22am

User_Master.UserCode IS One Fild And '_EmaillAddressInfo' IS A String

My Query Is

SELECT (CONVERT(VARCHAR(MAX), UserCode) + 'EmailAddressInfo').EmailId AS NewFieldName

FROM SUser_Master

But Error Is Occured : Cannot call methods on varchar(max)

Maciej Los 16-Nov-14 4:34am

Assuming, UserCode is VARCHAR(MAX) data field.