how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

what is index seek and index scan?

2 Answers  

---

What is tablesample?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

How will you go about resolving deadlocks?

0 Answers  

---

What is identity?

0 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Why do we use non clustered index?

0 Answers  

---