Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How many types of triggers are there?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

What is the parse query button used for?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What is the use of group by clause?

0 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---