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

why SQL server is more used to store database rather than
Access

Question Posted / guest

Answers were Sorted based on User's Feedback



why SQL server is more used to store database rather than Access..

Answer / murtaza

1.sql server supports Relational database Management Systems
whereas access does not support all the features of RDBMS.
2.sql server 2005 supports partitioning,bcp utility,Data
transformation services(DTS),SSIS which r not supported by
access
3.sql server 2005 supports crystal reports for reporting
services and can be use as an BI tool for OLAP Queries
access does not support crystal reports and does not support
BI tool.
4.sql server supports more large and mid size data processing
and access does not support volumnous data.

Is This Answer Correct ?    2 Yes 0 No

why SQL server is more used to store database rather than Access..

Answer / anilreddy

Access can store only 2 GB of data where as in SQLSERVER 2005 one column can store more than 2 GB of data

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

What are transactions in sql?

0 Answers  

How to create new table with "create table" statements?

0 Answers  

How many triggers are possible per table?

0 Answers  

how many bits ip address consist of? : Sql server database administration

0 Answers  

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

How to update multiple rows with one update statement in ms sql server?

0 Answers  

What does nvl stand for?

0 Answers  

How to concatenate two strings in SQL Server.

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories