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.

What are synonyms?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What are the elements of dbms?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

---

What to perform pattern match with the like operator?

0 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

What is the purpose of grouping data in a report?

0 Answers  

---