Answer Posted / manoj kumar singh

When we want to update row depending on certain criteria. we
will loop through all rows and update data accordingly.
There's where cursors come in to picture.

What do mean by xml datatype?

629

---

What is index, cluster index and nonclustered index?

523

---

How do you create a data source?

484

---

What is sqlcmd?

565

---

how can u get last observation in an unknown dataset ?

2010

---

---

How you can get the list of largest tables in a database?

535

---

Explain different forms of normalization?

539

---

What are the advantages to use stored procedures?

580

---

What is the difference between char and varchar2 datatype in sql?

551

---

can SSRS reports Cache results?

113

---

plss anybody specify tha constrian management system in dbms

1586

---

How to throw custom exception in Stored Procedure?

591

---

How to execute multiple stored procedures at one time in sql server?

518

---

State a few properties of relational databases?

670

---

List out what other servers you can use with ssrs?

93

---