Answer / paras

If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.

Answer / santosh kumar sharma

You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.

Answer / pradip jain

Become secure program from sql Injection.

How to connect sql server management studio express to sql server 2005 express?

0 Answers  

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

Why is the need for data conversion transformations?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

Explain index in sql server?

0 Answers  

---

---

How to truncate a table first before running a package?

1 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

What is filestream?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

What is the xml datatype?

0 Answers  

---