Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

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 are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

Create and insert into temp table in sql server?

0 Answers  

---

Explain syntax for viewing trigger?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

How to get number of days in a given year?

4 Answers   ADP,

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---