Answer / Amarnath Swamy

To drop an existing stored procedure in MS SQL Server, you can use the following command: DROP PROCEDURE [schema_name].[procedure_name]

Define full outer join in sql server joins?

1 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

What are 3 ways to get a count of the number of records in a table?

1 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is the purpose of data source?

1 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

Does an index slow down updates on indexed columns?

1 Answers  

---

What does it mean to manipulate data?

1 Answers  

---

How many partitions a clustered index has by default in sql server 2012?

1 Answers  

---

How to drop an existing table?

1 Answers  

---

Can we call future method from trigger?

1 Answers  

---

What is dml command?

1 Answers  

---