By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,450 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

Automatic creation of DB fields.

P: 10
i hv to increase my Database fields at runtime.
Example: i am hving fields like

1.company name

2. account number.

i hv to increase many account number for single company name.

how can i dynamically increase the field ie.(account number field).

FrontEnd - ASP.NET(C#)
BackEnd - SQL Server2005
Apr 1 '08 #1
Share this Question
Share on Google+
6 Replies


ck9663
Expert 2.5K+
P: 2,878
i hv to increase my Database fields at runtime.
Example: i am hving fields like

1.company name

2. account number.

i hv to increase many account number for single company name.

how can i dynamically increase the field ie.(account number field).

FrontEnd - ASP.NET(C#)
BackEnd - SQL Server2005
Increase size/length?

-- CK
Apr 1 '08 #2

P: 10
Increase size/length?

-- CK

Thankz for reply me,

i m not asking that, i m asking abt increase column,

like account number1, account number2....................
Apr 1 '08 #3

Delerna
Expert 100+
P: 1,134
Hi tina2626.
If i understand you correctly, your tables should be designed so that the quantity of account numbers for a company grows vertically.

IE
CompanyName Count AccountNo
Microsoft............1.......123456
Microsoft............2.......456789
AppleInc.............1......345677

etc
Apr 1 '08 #4

P: 10
Hi tina2626.
If i understand you correctly, your tables should be designed so that the quantity of account numbers for a company grows vertically.

IE
CompanyName Count AccountNo
Microsoft............1.......123456
Microsoft............2.......456789
AppleInc.............1......345677

etc

it should increase like this

ie

CompanyName........AccountNo1......AccountNo2..... ..AccountNo3 goes onnnn
Microsoft...................123456............2324 2343..............354543534
Microsoft...................456789............3423 423..................23424234


but it shld increase at runtime.

no account number creation at the time of table creation.
Apr 1 '08 #5

ck9663
Expert 2.5K+
P: 2,878
You might want to follow Delerna's structure.

-- CK
Apr 1 '08 #6

P: 92
Yeah, I also suggest you design your table similar to what Delerma suggested. Your idea is so complex that it comes with several issues. If you need more help, let us know.
Apr 2 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.