syntex of insert

7 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is shrink log file?

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

What is Index Segmentation ?

1 Answers   TCS,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What are the source of constraints?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

What is the default Port No on which SQL Server listens?

0 Answers  

---