Answer Posted / yamini

full form of xp is eXPerience.

Define union, union all, minus, intersect?

573

---

How to convert a table data in XML format in sql server?

2124

---

How to create an inline table-valued function?

540

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

89

---

‘Order by’ is not allowed in a view how can you sort information from a view?

589

---

---

Explain how dts is used to extract, transform and consolidate data?

587

---

What are orphan records?

554

---

How to add the custom code in Report?

99

---

How is a full-text index updated?

546

---

What is the difference between count () and rowcount ()?

528

---

Can we call stored procedure in trigger?

555

---

What is filtered index?

660

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

545

---

What is transactional replication?

565

---

Mention the uses of stored procedures.

575

---