Answer Posted / ausaf malik

xtreme power

What is the distinction amongst delete and truncate?

585

---

Define Unique Key?

594

---

How many columns can we include on clustered index ?

511

---

What is an entity-relationship diagram (erd)?

588

---

What is optimistic concurrency?

565

---

---

Mention the differences between local and global temporary tables.

567

---

What are the differences between local and global temporary tables?

560

---

how many type of indexing in database?

581

---

What are the differences between left join and inner join in sql server?

590

---

How you can get a list of all the table constraints in a database? : Sql server administration

518

---

What happens to a statement batch if there is a compilation error?

512

---

In which sql server version report builder introduced?

105

---

What is the template in sql?

539

---

How to copy data from one table to another table?

544

---

What are click through reports?

99

---