Difference between writing SQL query and stored procedure ?
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
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Is sql server difficult to learn?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is normalization and denormalization in sql server?
What does executeupdate return?
Why do you need a sql server?
Explain system rowset functions?
What are cascading parameters in ssrs reports?
What is function of ROLLUP ?
What is sleeping status in sql server?
What structure can you implement for the database to speed up table reads?
How to link tables in sql server?
What is a filestream?
what is nonclustered index
Explain collation?
Write a SQL query in order to merge two different columns into single column?