CODEWITHSUNDEEP
sql-server
benstpierre
benstpierre

Reputation: 33581

Best way to embded an array of strings into a column in SQL Server 2008

I am writing a print dispatch queue that passes the following for each row:

String Name
String TemplateName
String[] dynamicTextFields

Other that doing a 1:m table for dynamic text fields, how would I include my Array/List of strings in a single row's cell?

Upvotes: 0

Views: 30

Answers (1)

Szymon
Szymon

Reputation: 43023

In SQL Server, the best way is a properly normalised separate table in 1 to many relationship.

Any other solution (which would invariably be storing a list in some format (XML, JSON, whatever) in a single column is inferior to that in terms of performance as well as maintainability and clarity of your design.

Upvotes: 2

Related Questions