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 bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

What do you mean by acid?

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What is transaction server explicit transaction?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---