How to update comma seperated value in a column

Question

0.00/5 (No votes)

See more:

empId	emp_Name	emp_sal
1	   ram, name	     10000
2	   ramesh	     11000
3	   manish	     12000

update it emp name where id=1

empId	emp_Name	emp_sal
1	        ram, amit	10000
2	         ramesh  	11000
3	          manish	12000

What I have tried:

select empId, emp_Name, emp_sal from emp

Posted 1-Jan-18 22:33pm

DINESH K MAURYA

Updated 1-Jan-18 22:55pm

Add a Solution

Comments

Karthik_Mahalingam 2-Jan-18 4:48am

what is your expected output?
Use Improve question to add more info to the question.

GKP1992 2-Jan-18 4:54am

There is no way SQL server can know which value to update out of the various values separated by commas. You have to do it programmatically and update the whole value.
e.g. Initial Value = ram, name
Logic to determine final value, takes initial value as input
Final value as output of previous logic.
use this value to update row.
update emp set emp_name = "final value" where empId = "id"

1 solution

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)

OriginalGriff · Answer 1 · 2018-01-01T22:55:00

Simple: Don't use comma separated values in columns.
SQL server is not good at string handling: and storing data as comma separated values always gives you trouble. It's complex, and unnecessarily so.

Instead, use either separate columns (one for first name, one for second name if that's what you are storing) or a second table which interrelates values (if you are storing two employees under the same column and row). You can then use JOIN to combine the data back, and SQL is very good at those!