What is row-level compre?

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---