Answer Posted / gerrit

But if briefly, then do a backup restore using Microsoft SQL Server 2005. Then you will be able to open this base in Microsoft SQL Server 2012 - 11.0.2100.60.

How to use old values to define new values in update statements in ms sql server?

679

---

Explain the creation and execution of a user-defined function in the sql server?

576

---

What are the steps you will take to improve the performance of a poor performing query?

593

---

What are dml triggers and types of dml triggers?

547

---

How to filter out duplications in the returning rows in ms sql server?

634

---

---

what is the sql equivaent of the dataset relation object ?

1567

---

What are data driven subscriptions?

79

---

What is bcp? When does it used?

545

---

Explain transaction server consistency?

519

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

523

---

How to write a query with a full outer join in ms sql server?

558

---

Name 3 ways to get an accurate count of the number of records in a table?

569

---

Using the customer, and order table in northwind database, please write a query to produce xml?

649

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

577

---

What are the five characteristics of good data?

514

---