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
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 |
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 |
What are alternate keys?
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
How many types of stored procedures are there in sql server?
Is natural join and equi join same?
What is surrogate key? : sql server analysis services, ssas
How to change the ownership of a schema in ms sql server?
Describe in brief databases and sql server databases architecture.
Which are new data types introduced in sql server 2008?
what do you understand by change data capture?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
What is the purpose of floor function?
What is the use of keyword with encryption.