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.

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

What is collation sensitivity?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

How make remote connection in database?

1 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

How can you append an identity column to a temporary table?

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---