Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a limit on the number of fields in a SQL table
Message
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
00952948
Message ID:
00952982
Vues:
10
Hello Gerard,

Look for Maximum Capacity Specifications in Books Online...
It says that the limit is 1024 fields for a total of 8060 bytes per row...

I think 400 fields is a lot for a table... maybe you should review your data
model design. I can't imagine the INSERT/UPDATE stored procedures for this table :)

Best regards,
Alex
Alexandre Boudreault-Ferland
Chief Technology Officer
AZUR Technologies
http://www.xicommunity.ca
http://www.xiazur.com
http://endfunction.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform