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
Define tempdb database?
In what sequence sql statement is processed?
What is a hint?
What is a transact-sql statement batch in ms sql server?
How do I shrink an ldf file?
How can sql server instances be hidden?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How to modify an existing user defined function?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is sql server locking?
How to provide values to stored procedure parameters in ms sql server?
How to backup SQL Server Reporting Services ?
What is the contrast between sql and mysql?
What is tabulation?
What is sleeping status in sql server?