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.

What is a job?

3 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

1 Answers  

---

Are connections to sql server encrypted?

1 Answers  

---

Define left outer join?

1 Answers  

---

What is the difference between functions and scalar functions?

1 Answers   EXL,

---

How to insert stored procedure result into temporary table?

1 Answers  

---

What are the main sources of data?

1 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

How to replace given values with null using nullif()?

1 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1 Answers  

---