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,

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

How many types of local tables are there in sql server?

0 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---