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

What is federation member?

116

---

Can we create clustered index on composite key?

1161

---

What is a not null constraint?

1084

---

Does table partitioning improve performance?

1011

---

Where in ms sql server is ’100’ equal to ‘0’?

1126

---

What is 3nf normalization?

1046

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1950

---

What is normalization process?

1231

---

When we should use @@error?

1028

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1043

---

How can we solve concurrency problems?

1092

---

What is the dbcc command and why is it used?

1104

---

How to add a new dsn with the odbc driver for sql server?

1108

---

What is difference between createstatement and preparedstatement?

1166

---

What is the Difference Between Primary and Foreign Key?

1062

---