diffrence between function and procedure

5 Answers   Wipro,

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What does the on delete cascade option do?

0 Answers  

---

---

What is user defined stored procedures?

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

How does normalization work?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is pessimistic concurrency?

0 Answers  

---