Answer Posted / 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 is the purpose of update statistics and scope_identity() function?

1159

---

When would you use a before or after trigger?

957

---

What is the difference between system objects and user objects?

1213

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6949

---

When would you prefer to have a minimum number of indexes?

962

---

How to create percentile function?

159

---

What command would you use to create an index?

1108

---

what is sql server? : Sql server database administration

1044

---

Explain transaction isolation levels in sql server?

1184

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1121

---

What is a transact-sql statement?

1130

---

What is the library index called?

1110

---

How do you delete a trigger?

1034

---

What happens on checkpoint?

1070

---

What is inner join? Explain with an example?

1286

---