Answer / ashis

update <tablename> set <columnname>=<value>
where <condition>

Answer / kumari

--table name = production
--coloum name = description(one column name)
--categoryname is another column name


update dbo.production
set
discription='xxxxxxxxxxx'
where [check condition]
categoryname='vitamins'

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

Which is the main third-party tool used in sql server?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

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

0 Answers  

---

What is the command used to get the version of sql server?

1 Answers  

---

---

What is a field in a table?

0 Answers  

---

Explain about the command-line tool SQLCMD?

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

What is the return type of executeupdate ()?

0 Answers  

---

What is the difference between for auto and for nested?

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---