Answer Posted / pankaj dwivedi

xp_cmdShell 'bat file'

What is nested transaction?

536

---

How to create a simple stored procedure in ms sql server?

519

---

When do you think a developer should use sql server-based cursors?

520

---

How to filter records of table in SQL SERVER?

601

---

How to delete duplicate rows?

551

---

---

What is the difference between composite index and covering index?

509

---

Explain how to integrate the ssrs reports in application?

522

---

What are cursors stored procedures and triggers?

514

---

What is merge statement?

627

---

How do I open port 1433?

528

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

500

---

How to assign new column names in a view?

509

---

How to create function with parameter in sql server?

557

---

How sql server executes a statement with nested subqueries?

511

---

How to create an multi-statement table-valued function?

529

---