Interested to Buy Any Domain ? << Click Here >> for more details...
why SQL server is more used to store database rather than
Access
- 2 Answers
- 4475 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
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is row_number function?
what is bit datatype? : Sql server database administration
How does clustered and non clustered index work?
Why do we use trigger?
Where sql server usernames and passwords are stored in a sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is exporting utility?
Can binary strings be converted into numeric or float data types?
What are different types of schemas?
What is filestream?
Can we use custom code in ssrs?
How to convert a unicode strings to non-unicode strings?
How is table type constraint applied to a table?
