Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between ms access and sqlserver
- 1 Answers
- 4779 Views
- C DAC, CDAC, I also Faced
- E-Mail Answers
Answer / appu
Access is installed as part of the Microsoft Office suite.
SQL Server can be quite expensive.
Access is more suited for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Access over SQL Server is for compatibility/sharing.
SQL Server was designed to have many hundreds, or even thousands of users accessing it at any point in time.
| Is This Answer Correct ? | 11 Yes | 1 No |
Do you know how to send email from database?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Some queries related to SQL
How do you find the error, how can you know the number of rows effected by last SQL statement?
How can you start sql server in different modes?
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
What is the importance of a recovery model?
Can we do dml on views?
What do you mean by an execution plan? Why is it used?
About Indexed Views? with example? plz reply...
When do you create cluster and noncluster index?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
