Mc27 Mc27 - 1 year ago 110
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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download