Mc27 Mc27 - 7 days ago 7
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

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.