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 are the rules to use the rowguidcol property to define a globally unique identifier column?

1075

---

What is the most common type of join?

1038

---

What gets stored inside msdb database?

1309

---

What are Row versions of DataRow?

1080

---

Explain the phases a transaction has to undergo?

1111

---

Mention the uses of stored procedures.

1006

---

How to set a database state to offline in ms sql server?

1104

---

What is the current pricing model of SQL Azure?

104

---

Explain the concept of view and Types of views in SQL server?

1034

---

How to use “drop” keyword in sql server and give an example?

1193

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1018

---

What sql server means?

1004

---

What does the update command do?

1173

---

What are four major operators that can be used to combine conditions on a where clause?

1090

---

How to concatenate two strings in SQL Server.

1203

---