Sql Stored Procedures | Sql Stored Procedures | Stored Procedures in SQL | How to create store proc

Stored Procedure:
A stored procedure is a prepared SQL code that you can be Stored or saved for later use in database
[so the code can be reused over and over again.]
Where should we do need Stored Procedure
1. Reusable Execution plan
Rather than the query, Stored Procedure makes a cache of the Execution plan while saving it which can be reused
2. Sharing
Stored procedure can be shared among the different applications over the queries that used within the code.
3. Protection over Sql Injection
Sp provides security over injection attacks by using the checks rather than the query
4. One place change
It provides with a benefit to change in one place that reflect changes wherever it is used.
5. Executing permissions
SP has a feature where we can give the executing permission only to a user or role
SQL Syntax:
CREATE PROCEDURE StoredProcedure_Name
@PARAM_1 DataType,
@PARAM_2 DataType,
.......
@PARAM_N DataType
AS
BEGIN
SET NOCOUNT ON;
--SQL logic
END
Let's take a look in sql server qeury window
CREATE PROCEDURE [dbo].[EmployeeMonthlySalary_GetMonthlySalary]
@Year INT,
@Month INT
AS
BEGIN
SET NOCOUNT ON;
SELECT
ei.Fistname
, ei.Email
, ei.GrossSalary
, sht.HeadNameType
, sh.SalaryHeadName
, ems.SalaryYear
, ems.SalaryMonth
, ems.SalaryDate
, ems.SalaryAmount
FROM [dbo].[EmployeeMonthlySalary] ems
INNER JOIN [dbo].[EmployeeInfo] ei ON ei.Id=ems.EmployeeId
INNER JOIN [dbo].[SalaryHead] sh ON sh.Id=ems.SalaryHeadId
INNER JOIN SalaryHeadType sht ON sht.Id=sh.SalaryHeadTypeId
WHERE
ems.SalaryYear=@Year
AND ems.SalaryMonth=@Month
END
GO
EXEC [dbo].[EmployeeMonthlySalary_GetMonthlySalary] 2019,11
Searchable Keywords:
SQL Stored Procedures - What They Are, Best Practices
Stored procedures in sql server
Advanced SQL Tutorial | Stored Procedures + Use Cases
CREATE PROCEDURE Statement| SQL Server Tutorial
SQL Server Programming - Stored Procedure Basics
Advanced SQL: Subqueries in SQL, stored procedures & more
Procedure Tutorial in SQL
Understanding stored procedures - SQL Server Video Tutorial
SQL Server Stored Procedure - How To
SQL TUTORIAL - How to create a Stored Procedure
SQL Server - Procedures and Programming
SQL Stored Procedures | CREATE PROCEDURE Statement| SQL Server Tutorial for Beginners
How to Write Stored Procedure in SQL Server for Beginners
Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL
SQL Stored procedure Hindi | Stored Procedure in SQL Server for Beginners
Stored procedures in sql server
Stored Procedure in SQL Server by Technical Aroushay
SQL Stored Procedure | Stored Procedure With and Without Parameters
T-SQL - Stored Procedures
SQL Stored Procedure Tutorial | CRUD Operations Explained With Example
Mix - Stored procedures sql
SQL Programming | Stored Procedure | Create and Execute a User Stored Procedure
SQL Stored Procedures, Functions, and Views
STORED PROCEDURE || MS SQL SERVER BANGLA TUTORIAL SERIES
What is in SQL stored procedure?
What is the purpose of a stored procedure?
What is stored procedure in SQL and types?
How to create a stored procedure in SQL Server?
sql stored procedure example
sql stored procedure with parameters
stored procedure and function in sql
how to execute stored procedure with parameters in sql server
types of stored procedure in sql
how to create a stored procedure in sql
stored procedure vs function
stored procedure in snowflake
Channel References:
@rejawebs @MSSQLDBAsLife @Microsoft @MSSQLBI_Tutorial @tsqlssis7932 @SQL @sqlquery @sqlquery4042 @sqlinsertdeleteupdate @Amit.Thinks @biwithmina7066 @Programming Only @playwithcode @mycodingproject43
@WiseOwlTutorials @Alex The Analyst
Hash Tag:
#sql #sqlserver #sqlsubquery #mssqlserver #microsoft #sqltips #sqlinsertdeleteupdate #rejawebs official video
#sql_stored_procedures_-_what_they_are,_best_practices
#stored_procedures_in_sql_server
#advanced_sql_tutorial_|_stored_procedures__use_cases
#create_procedure_statement|_sql_server_tutorial
#sql_server_programming_-_stored_procedure_basics
#advanced_sql:_subqueries_in_sql,_stored_procedures_&_more
#procedure_tutorial_in_sql
#understanding_stored_procedures_-_sql_server_video_tutorial
#sql_server_stored_procedure_-_how_to
#sql_tutorial_-_how_to_create_a_stored_procedure
#sql_server_-_procedures_and_programming
#stored_procedures_in_sql_server
#t-sql_-_stored_procedures
#mix_-_stored_procedures_sql
#sql_stored_procedures,_functions,_and_views
#what_is_in_sql_stored_procedure?
#what_is_the_purpose_of_a_stored_procedure?
#what_is_stored_procedure_in_sql_and_types?
#how_to_create_a_stored_procedure_in_sql_server?
#sql_stored_procedure_example
#sql_stored_procedure_with_parameters
#stored_procedure_and_function_in_sql
#types_of_stored_procedure_in_sql
#how_to_create_a_stored_procedure_in_sql
#stored_procedure_vs_function
#stored_procedure_in_snowflake