Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using sql server over ms access
or why should one use sql instead of ms access
- 2 Answers
- 13701 Views
- CMS, Impetus, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
Some SQL Server 2000 and Access 2000 products limits:
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus
linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited 255
columns per table 1024 255
table size limited 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
| Is This Answer Correct ? | 24 Yes | 6 No |
Post New Answer View All Answers
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Why do we use stored procedures in sql server?
What are the new security features added in sql server 2012? : sql server security
Can we insert data if clustered index is disabled?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is the full form of ddl?
How many types of the database links?
What is clustered primary key?
What command would you use to create an index?
Can one drop a column from a table?
Define compound operators?
What are system databases in ms sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to change parameter value inside the report?
What is factless fact table? : sql server analysis services, ssas
