What are truncate options available in sql server? : sql server database administration

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

Define left outer join?

0 Answers  

---

Explain linked server in sql?

0 Answers  

---

What are magic tables in sql server?

0 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

Explain transaction server isolation?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---