Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
flamblaster
Constraint Violating Yak Guru
384 Posts |
 Posted - 2013-08-29 : 19:27:51
|
| I came across a product for form creation that adds a new record for each field that is created. In essence, you can have unlimited fields because everytime the user creates a new field, the product inserts a new row into the "Field" table. I was wondering if anyone knows the term for this model type. I'd like to research it more.Basically:[/CODE]declare @Fields table (ColumnName Varchar(20), DataType VarChar(20))insert into @Fields (ColumnName, DataType)values ('LastName', 'Varchar(30)'),('FirstName', 'Varchar(30)'),('Age', 'Int')[CODE]If anyone knows the term to search, I'd appreciate it! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
flamblaster
Constraint Violating Yak Guru
384 Posts |
Posted - 2013-08-30 : 00:04:27
|
| Aha! Thanks! Kept searching for the wrong terms. This is great, thanks Khtan. |
 |
|
|
flamblaster
Constraint Violating Yak Guru
384 Posts |
Posted - 2013-08-30 : 00:09:30
|
| Aha! Thanks! Kept searching for the wrong terms. This is great, thanks Khtan. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-08-30 : 21:45:17
|
you are welcome
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-08-30 : 21:45:24
|
you are welcome
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Vertical Model