Answer / priyanka rani

By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---

What does nvl stand for?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---

What is the use of for clause?

0 Answers  

---

---

What is rtm version in sql server?

0 Answers  

---

Explain about service Broker functions?

0 Answers  

---

What is an identity column in insert statements?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

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,

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---