Answers for "procedure and function in sql"

SQL
0

what is procedure in sql

-Stored procedure is a group of SQL
statements that has been created 
and stored in the database.
-A stored procedure will accept input 
parameters so that a single procedure
can be used over the network by several
clients using different input data.
-A stored procedures will reduce
network traffic and increase the performance. 
If we modify a stored procedure all the
clients will get the updated stored procedure.

Sample of creating a stored procedure
CREATE PROCEDURE test_display AS
SELECT FirstName, LastName FROM tb_test
EXEC test_display
Posted by: Guest on January-28-2021

Code answers related to "procedure and function in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language