Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between ms access and sqlserver
- 1 Answers
- 4774 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 |
What do you understand by recursive stored procedure?
What happens when transaction log is full?
How to get the count of distinct records. Please give me the query?
Describe how to use linked server?
What types of integrity are enforced by a foreign-key constraint
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
What is user defined datatypes and when you should go for them?
write a query to remove duplicate records without using primary key column?
What is the use of floor function in sql server?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
Can we use max in where clause?
What is sub query and its properties?
-
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)
