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 #temp and @table variable in SQL server?
What are the different types of sql server replication? : sql server replication
What are the different types of backup avaible in SQL SErver
What is the maximum size of a row in sql server?
How to get the definition of a trigger back?
How to get the definition of a stored procedure back?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is surrogate key? : sql server analysis services, ssas
What is the difference between having clause and where clause in sql server?
How many categories of functions based their return modes?
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?
What is the difference between DTS and SSIS?