Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

---

Why use “nolock” in sql server?

0 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

How do you know if sql server is running on your local system?

0 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is the largest component inside a field?

0 Answers  

---