sample code for create dynamic sql server table

Question

I trying to build a site that is works with electronic currencies. Example, a WebMoney currency has its own set of parameters, such as wmid etc. And uKash has its own parameters also a series of other parameters, such as emails etc. Now it is not clear how many currency site administrators is introduced while the unknown parameters I thought to myself, bank currency should be constructed in a dynamic table that the user can set the parameters. Know i don't how to implement it?

here you want to create a table with dynamic number of columns in it? — AnandPhadke
– AnandPhadke, Commented Sep 4, 2012 at 7:13

podiluska · Accepted Answer · 2012-09-04 09:12:22Z

1

Tables can't have dynamic columns

You can add a table for each form of web currency that contains the parameters those currencies require = ie: A WebMoney table, a uKash table, etc.

Or you can add an XML column to your main table that contains the variable data information for the specific web currency in question. eg:

<webcurrency type="webmoney">
    <wmid>1</wmid>
<webmoney>

and

<webcurrency type="uKash">
    <email>[email protected]</email>
<webmoney>

Given your intention to allow for future currencies, perhaps the second choice is preferable.

answered Sep 4, 2012 at 9:12

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

sample code for create dynamic sql server table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related