What is the maximum number of index per table?

0 Answers  

---

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,

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

What are the differences between clustered and non-clustered index?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

How secure is sql server database?

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

What is difference between unique and primary key?

0 Answers  

---