Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / what is the stored procedure? create a procedure to find the record by stu_id from the student table
Ask Question

What is the Stored Procedure? Create a Procedure to find the record by stu_ID from the student table

Revati S Misra 651 24 Mar 2023

What is the Stored Procedure? Create a Procedure to find the record by stu_ID from the student table.

mysql databasemysql
Updated 12 Apr 2023
Revati S Misra
Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Message

1 Answers

Krishnapriya Rajeev
Krishnapriya Rajeev 12 Apr 2023
Report Abuse

In SQL, a stored procedure is a pre-compiled collection of SQL statements and procedural logic that can be executed repeatedly by invoking the procedure. Stored procedures are stored in the database and can be used to encapsulate complex business logic, improve performance, and simplify database administration.

Here's an example of how to create a stored procedure in SQL Server to find a student record by their stu_ID from the student table:

CREATE PROCEDURE find_student
  @stu_ID INT
AS
BEGIN
  SELECT * FROM student WHERE stu_ID = @stu_ID
END

In this example, the CREATE PROCEDURE statement is used to create a stored procedure called find_student. The procedure takes one input parameter, @stu_ID, which is an integer representing the student ID.

The SELECT statement is used to retrieve the student record from the student table where the stu_ID matches the input parameter @stu_ID.

To execute the stored procedure, you can use the EXECUTE statement, passing in the value of @stu_ID as a parameter:

EXECUTE find_student @stu_ID = 12

This will return the student record from the student table where the stu_ID is 12.

advertising