Answer / Sudha Tiwari

The UPDATE command in SQL Server modifies existing records within a table. It takes the form:nnUPDATE table_namenSET column1 = new_value1, column2 = new_value2...nWHERE search_condition;nThe WHERE clause is optional and specifies which rows to update.

How to download and install microsoft sql server management studio express?

1 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1 Answers  

---

What are the kinds of subquery?

0 Answers  

---

Name few of the dcl commands in sql?

1 Answers  

---

What are the different types of replication are there in sql server 2000?

1 Answers  

---

What is inline variable assignment?

1 Answers  

---

Can an automatic recovery be initiated by a user?

1 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What is optimistic concurrency?

1 Answers  

---

What is logon trigger?

1 Answers  

---

Can you type more than one query in the query editor screen at the same time?

1 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---