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 |
|
belvintheodore
Starting Member
2 Posts |
 Posted - 2008-06-20 : 06:41:20
|
| hi all. i just want to know if i can create a dynamic table. i mean a table which expands itself based on the requirement. or a table can only be static???Cheers!!!Bel. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-06-20 : 06:46:04
|
| What do mean by "table which expands itself based on the requirement"?Do you mean adding columns at runtime?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
belvintheodore
Starting Member
2 Posts |
Posted - 2008-06-20 : 06:54:35
|
| ya. i extract some content and store it in a table. the content may differ. so i have to add or remove columns at run time. is it possible???Cheers!!!Bel. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-20 : 06:56:00
|
quote:
Originally posted by belvintheodore
ya. i extract some content and store it in a table. the content may differ. so i have to add or remove columns at run time. is it possible???Cheers!!!Bel.
Yup. you can do it by simply updating field value. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-20 : 18:20:44
|
| In any case, make sure you read this fullywww.sommarskog.se/dynamic_sql.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-06-21 : 06:31:35
|
| Just implement the commands as normal , but in a dynamic wayJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
dynamic tables???