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 |
How to use "begin ... End" statement structures in ms sql server?
How can sql server instances be hidden? : sql server security
What are the benefits of filtered indexes?
Can you explain different types of locks in sql server?
Is sql server free?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
from the table display the 2nd highest salary? and also the least 2nd salay?
What is xdr?
Give a example to search fr a string in all stored procedure in sql server.
How to list all user defined functions in the current database?
Create and insert into temp table in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
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)