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.

Explain about system stored procedure?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What is query and its types?

0 Answers  

---

How to get a list all databases on the sql server?

0 Answers  

---

What is update_statistics command?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---