1. fauzanf New Member

   Dear My Friends,
   I have a question...
   How many field in table can be inserted?
   I using Microsoft SQL Server 2000
   Thanks & Regards,
   Fauzan
   

   fauzanf, Jun 30, 2009

   #2
2. Madhivanan Moderator

   Read about Maximum capacity specifications in sql server help file
   

   Madhivanan, Jul 1, 2009

   #3
3. FrankKalis Moderator

   To add to Madhivanan: This limit is rather theoretical. If you come anywhere it, I would think there is a serious problem with your database design.
   Anyway, if I remember correctly, SQL Server 2000 can have as many as 1.024 columns per base table.
   

   FrankKalis, Jul 1, 2009

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in