| Author |
Topic |
|
adya
Starting Member
31 Posts |
 Posted - 2008-09-16 : 11:38:14
|
| i wanted to know how can we add columns to an existing tables dynamically, as the user enters information.frontend is in asp.net 3.5 and backend is sql server 2005.thanx in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-16 : 11:47:59
|
| its not at all a good approach. why do you want to add columns dynamically from application? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-16 : 11:48:16
|
| This is a very bad idea and a very bad design. Yes it is possible, but you should rethink your system if this is what you want to do. There is probably a much better way to achieve the end result.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
adya
Starting Member
31 Posts |
Posted - 2008-09-16 : 13:52:34
|
| i am storing the skills of a candidate in a table as he adds them while registering for a job.How else can i add that information for a particular candidate.Thanx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
adya
Starting Member
31 Posts |
Posted - 2008-09-16 : 14:04:54
|
| i have 2 tables:tblSkills, which stores the following information:SkillsID(*)SkillsNameand another table tblSkillsCandidate, which stores CandidateIDSkillNameYearsOfExperienceI want to have a single tuple for each candidate who enters his skills, such asCID Skill Experience Skill Experience Skill Experience123 C++ 2 ASP 2 JAVA 1Is it a bad idea?or should i just have multiple rows for each candidate?Thanx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
adya
Starting Member
31 Posts |
Posted - 2008-09-16 : 14:16:25
|
| thanx for the answer!if you can let me know, which normal form was being violated? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
adya
Starting Member
31 Posts |
Posted - 2008-09-16 : 14:29:11
|
thanx! |
|
|
|
|
add columns dynamically??