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'

Explain what is use of dbcc commands?

0 Answers  

---

Is null in sql server?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

---

How many cores do I need for sql server 2016?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

In what sequence sql statement is processed?

0 Answers  

---

What is filter index?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What is 4nf in normalization form?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---