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 |
|
John Sourcer
Yak Posting Veteran
91 Posts |
 Posted - 2008-01-15 : 09:19:47
|
| Hi Gurus,Advice if possible. I have a table of items with properties. I store the properties in a lookup table as follows:ProductsID| OBJECT1 | Banana2 | Apple3 | TomatoPropertiesID| Property1 | Fruit2 | Vegetable3 | SweetProductsPropertiesID | ProductID | PropertyID1 | 2 | 12 | 2 | 3In ProductsProperties is it better to Delete/Insert or check for exists and then delete or add? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-15 : 09:23:23
|
| How will you be performing insert/deletes? |
 |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-01-15 : 09:23:28
|
| ok so what I understood is that your Apple is a Fruit and is Sweet, what next? |
|
|
|
|
|
|
Delete/Insert vs Update on look up table