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 type of Index will get created after executing the above statement?

1044

---

Write a program using SQL queries to find a unique entry in a table.

940

---

What is 2nf in normalization?

944

---

How to connect sql server management studio express to sql server 2005 express?

965

---

What is ddl command?

926

---

What is database dimension? : sql server analysis services, ssas

1031

---

What is CTE in SQL

874

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1001

---

What is a sql join?

951

---

What are advantages of ssrs or why we should use ssrs?

129

---

Explain a join?

1002

---

What is a data source file?

921

---

What is query cost in sql server?

934

---

How do I uninstall sql server 2014?

873

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

935

---