Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / anil

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

what are batch in sql server?

2 Answers   Satyam,

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

How will you know when statistics on a table are obsolete?

0 Answers  

How to connect to a sql server using odbc_connect()?

0 Answers  

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

What are the advantages of using stored procedures?

0 Answers  

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

Define indexes?

0 Answers  

What is difference between standardization and normalization?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories