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'

What are synonyms?

1 Answers  

---

How do use Having,Group by,Group function in SQL?

1 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1 Answers  

---

Why use update_statistics command in sql server?

1 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

Where the sql logs gets stored? : sql server database administration

1 Answers  

---

What is ddl and dml commands?

1 Answers  

---

What are sql servers used for?

1 Answers  

---

What is the definition for sql server 2000?

1 Answers  

---

How to provide values to stored procedure parameters in ms sql server?

1 Answers  

---

Explain about link server in sql server?

1 Answers  

---

Explain what is log shipping?

1 Answers  

---