what are the main differences between ms access and sqlserver
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 |
What is awe?
What happens if you are trying to access a schema not owned by you?
How do you use a subquery to find records that exist in one table and do not exist in another?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
Define Unique Key?
How to execute multiple stored procedures at one time in sql server?
What do you understand by a view? What does the with check option clause for a view do?
How to truncate a table first before running a package?
How do I run sql server 2014?
What is the difference between join and inner join?
How do I find the query plan in sql server?
How to write a query with an inner join in ms sql server?