Mc27 Mc27 - 10 months ago 81
SQL Question

Save data set with Dynamic columns in Sql Server

I have some excel in which the column names are numbers are dynamic, How can I design a table structure to save it in sql server table.

Since its dynamic I can't keep a specific table structure.Please suggest a solution.

Answer Source

SQL servers don't deal well with dynamic content, as they cant index it or create keys. Your best bet would be to use the XML or JSON data types.