Click here to Skip to main content
15,895,667 members
Search within:


Maximum How Many Records Can I Have(Insert) In A Table(I.E That Contains 5 Columns)?
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
SQL-Server-2008
maximum how many records can i have(insert) in a table(i.e that contains 5 columns)?
Posted
Updated 4-Jan-14 4:55am
v2
Add a Solution
Comments
Maciej Los 4-Jan-14 10:30am    
Please, be more specific and provide more details...
Richard MacCutchan 4-Jan-14 10:34am    
As many as you need. But you could look at the documentation for exact details.
Maciej Los 4-Jan-14 10:40am    
My virtual 5, Richard!
Richard MacCutchan 4-Jan-14 10:50am    
Thanks. Is it me, or are we getting a lot more questions of this nature since the New Year?
Maciej Los 4-Jan-14 10:53am    
Unfortunately, the count of this nature questions is growing to the infinity this year ;(

1 solution

If you look here: http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx[^] Microsoft publish the limits for each version of SQL Server. In all cases, the maximum row count is "dependant on available storage", there is no built in restriction on the number you can have, regardless of the column count.

Be aware though that SQL server is limited to a total database size of only 524,272 terabytes, which may prove a significant problem if you are trying to backup the whole of Google...
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Check how many columns contain value in each row of table
how many maximum columns and rows can a table have?
Insert into Many to Many tables in EF
How to join table columns and view columns, store in postgres and to perform incremental load in ssis package.
Maximum no of columns that a table can have
Table records updates and inserting
Maximum integer value in oracle table column
generic function to insert a record
Data Converted to BigInt contains Decimal with E Proceeding with Plus sign
Computed Column / Function / Trigger to link multiple Tables and insert data into another table

Advertise
Privacy
Cookies
Terms of Use
Last Updated 4 Jan 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900