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'

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

What is shared lock?

0 Answers  

---

Why we need a group by clause?

4 Answers  

---

What do you understand by the analysis services in sql server?

0 Answers  

---

---

What do you mean by subquery?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

What is the difference between for trigger and after trigger?

0 Answers  

---

How connect excel to sql server?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---