What are the advantages of using sql server over ms access
or why should one use sql instead of ms access




Answers were Sorted based on User's Feedback



What are the advantages of using sql server over ms access or why should one use sql instead of ms..

Answer / 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

What are the advantages of using sql server over ms access or why should one use sql instead of ms..

Answer / rajeshwari

it is an query language with an structure so we esily
access the data from data base

Is This Answer Correct ?    5 Yes 14 No

Post New Answer




More SQL Server Interview Questions

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  


What are the advantages of stored procedure in sql server?

0 Answers  


What is indexing a document?

0 Answers  


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  


How can I change procedure name in sql server?

0 Answers  






What are indexers?

0 Answers  


What is constraints and its types?

0 Answers  


Explain different types of locks in sql server.

0 Answers  


Do you know what are pages and extents? : SQL Server Architecture

0 Answers  


What is an example of a primary key?

0 Answers  


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  






Categories