Interested to Buy Any Domain ? << Click Here >> for more details...
why SQL server is more used to store database rather than
Access
- 2 Answers
- 4612 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is raiseerror? What is raiseerror?
What is difference between stored procedure and user defined function?
How many types of triggers are there?
What is user-defined functions? What are the types of user-defined functions that can be created?
Do you know what is user defined datatypes and when you should go for them?
What is the default schema of your login session in ms sql server?
What is difference between getdate and sysdatetime in sql server 2008?
what is a transaction? : Sql server database administration
What is the difference between the application object and session object?
Is INSTEAD OF trigger directly applicable to Table ?
what are acid properties? : Sql server database administration
What are group functions in query statements in ms sql server?
How to invoke a trigger on demand?
What are the advantages of user-defined functions over stored procedures in sql server?
What is sql view?
