I would like to know about maximum number number of fields that can be created in a table. my requirement is to meet data entry in morethan 300 fields. I am using SQL 2000. if impossible is there any other method to incorporate additional fields?
Please reply as soon as possible.
linHi linsha,
from memory its 1024 for SQL2k.
I would suggest you take a look again at the data structure and see if you can do some normalisation - take a look at this article for some background reading if required.
Regards Purple|||
Quote:
Originally Posted by linsha
hi...
I would like to know about maximum number number of fields that can be created in a table. my requirement is to meet data entry in morethan 300 fields. I am using SQL 2000. if impossible is there any other method to incorporate additional fields?
Please reply as soon as possible.
lin
if you have that many fields you might think about many to many relationships. Read up onnormalizations
nomad|||thankyou for your reply . Let me try it .
lin
No comments:
Post a Comment