Answer Posted / bhagyashri jain

By Command
Execute Procedurename parameter1 ,parameter2,......
u can use
exec Procedurename parameter1 ,parameter2,......

What are the different SQL Server Versions you have worked on?

561

---

How to drop an existing table with "drop table" statements in ms sql server?

556

---

What is cursors?

646

---

What is use of except clause? How does it differ from not in clause?

558

---

What is the use of custom fields in report?

561

---

---

What is collation sensitivity?

557

---

 Explain what is sql override for a source taLle in a mapping?

577

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

565

---

How fixed length strings are truncated and padded?

556

---

Explain magic tables in sql server?

555

---

What types of Joins are possible with Sql Server?

553

---

What happens when converting big values to numeric data types?

571

---

If a table does not have a unique index, can a cursor be opened on it?

517

---

How many types of triggers in sql server?

525

---

what stored procedure can you use to display the current processes? : Sql server administration

532

---