Insert string of comma seperated strings in sql server

Question

I want to Insert "'765','76','70','70','80','82','11'" into nvarchar column in sql-server. How it's possible?

What have you tried so far, and what exactly was the problem? — Mureinik
– Mureinik, Commented Sep 23, 2017 at 14:32
Please note that we often see people putting comma-separated values into one column in SQL, and then they get all sorts of problems trying to get them out individually. There is a better way of storing the data if you are going to need the individual parts. — Andrew Morton
– Andrew Morton, Commented Sep 23, 2017 at 14:48
Seriously reconsider doing this. It's a terrible idea and violated 1NF — S3S
– S3S, Commented Sep 23, 2017 at 17:04
@AndrewMorton I have a key-value table as config. Imagine these are codes of some info that are forbidden in filtering a query result. So I have a key to select config, and according value, in addition to Id. The Value column type is nvarchar, and in my case these codes are string to. — Elnaz
– Elnaz, Commented Sep 24, 2017 at 5:22

Ilyes · Accepted Answer · 2017-09-23 14:53:55Z

1

Here you go:

DECLARE @N NVARCHAR(MAX);
SET @N = '''765'',''76'',''70'',''70'',''80'',''82'',''11''';
SELECT @N AS Result;

Result:

+-------------------------------------+
|               Result                |
+-------------------------------------+
| '765','76','70','70','80','82','11' |
+-------------------------------------+

edited Sep 23, 2017 at 14:53

answered Sep 23, 2017 at 14:45

Ilyes

15k5 gold badges31 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert string of comma seperated strings in sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related