What are the dmvs? : sql server database administration

0 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

What is the need for group functions in sql?

0 Answers  

---

How do I create a partition table in sql server?

0 Answers  

---

---

What are the types of constraints?

1 Answers  

---

What are the character string functions supported by sql server 2005?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Can group by and orderby be used together?

0 Answers  

---

How does a profiler work?

0 Answers  

---

How to find table changes in sql server?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---