Inserting an array into sql server table

Question

create proc InsertTagsForArticle(@ArticleID int, @TagIDsList nvarchar(max))
as
--...........

The parameter @TagsList contains IDs of tags separated by comma: "18,22, 23". How to insert these IDs into table by more rational way?

EDIT: The question is how to insert an array into sql server table, but not how to parse an array. It's something like foreach operator.

Sergio Tulentsev · Accepted Answer · 2011-12-06 14:26:07Z

2

As SQL server doesn't support native arrays, there's not much that you can do.

Your requirements will dictate what's better for you. But usually normalized approach is working better.

answered Dec 6, 2011 at 14:26

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

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

Comments

marc_s · Accepted Answer · 2011-12-06 14:25:01Z

1

You need to use e.g. a user-defined function that splits the comma-separated string into a table - see e.g. here:

or many more available on the interwegs - just Google or Bing for "split comma-separated string into table" and you'll have thousands of hits....

answered Dec 6, 2011 at 14:25

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges