Answer / Anand Kumar Tiwari

{"recursion": "A stored procedure can call itself in a process known as recursion. Recursive procedures can be useful for handling tasks that require repeated subtasks, such as calculating factorials or generating tree structures.",n"levels of nesting": "The maximum number of levels of nested stored procedures in SQL Server is 32. However, Microsoft recommends keeping the number of nested stored procedure levels to a minimum to avoid potential performance issues and to maintain manageability".}

What is read uncmmited?

1 Answers  

---

What does man by sql wildcard characters in sql server?

1 Answers  

---

How to update values in a table with update statements in ms sql server?

1 Answers  

---

Explain different types of collation sensitivity?

1 Answers  

---

How important do you consider cursors or while loops for a transactional database?

1 Answers  

---

What is xml datatype?

1 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

1 Answers  

---

Can primary key be null?

1 Answers  

---

Explain about Views?

1 Answers   Infosys,

---

How to find index size for each index on table?

1 Answers  

---

How to create prepared statements using odbc_prepare()?

1 Answers  

---