What is Stored Procedure in SQL-Server?
- Stored Procedure is write SQL Query in Specific format in SQL Server and call them from your application, instead of writing queries inside your program code.
- Stored Procedures are precompiled Transact-SQL statements which is stored in a SQL Server database.
- Stored procedure is a simple SQL Statement, which is precompiled.
- SP Increase the performance of your application.
Create a Stored Procedure in SQL-Server
CREATE PROCEDURE [STUDENT_SELECT]
//here is your parameter for insert/update/delete purpose.
SELECT * FROM STUDENTMST
(Visited 1 times, 1 visits today)