Answer Posted / pratap

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance. Stored procedures can be used to help ensure the integrity of the database.
CREATE PROCEDURE procedure_name
@param data_type = default_value,
@param data_type = default_value,
@param data_type = default_value
AS

BEGIN
DELETE FROM Employees
WHERE EmployeeId = @EmployeeId;
END

How would we use distinct statement? What is its use?

1064

---

What is the difference between coalesce() & isnull()?

1120

---

What is the default server name for sql server?

1147

---

Can we store videos inside the sql server table?

967

---

What are the different authentication modes in sql server?

1100

---

How do I view a stored procedure in sql server?

974

---

What are different types of data sources?

1006

---

What is Command line parameters in PLSQL.?

1123

---

What is sql view?

1008

---

Explain what are the events recorded in a transaction log?

998

---

How do I install only the client tools of sql server 2000?

1058

---

What is the server name in sql server?

997

---

Can you explain what are commit and rollback in sql?

929

---

Explain difference between control flow and data flow?

955

---

What is a scheduled job or what is a scheduled task?

945

---