Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

Explain sql delete command?

0 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

---

what type of indexes physically sort data?

3 Answers  

---

What are the advantages dts has over bcp?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---