what are the main differences between ms access and sqlserver
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible for a stored procedure to call itself or recursive stored procedure?
Describe in brief system database.
What are logical/boolean operations in ms sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is outer join in sql server joins?
Comment,Datatypes are unlimited
Define outer join in sql server joins?
Do you know the cursor optimization tips?
Why do we need different type of parameter?
What the different types of Replication and why are they used?
what are the disadvantages of cursors? : Sql server database administration
What is a mixed extent?
What is the datatype of rowid?
What is a functions and types in sql server?
query processing