What is a function in SQL? Create a function that returns stu_Name when passed stu_ID.

Question

Krishnapriya Rajeev · Answer

In SQL, a function is a piece of code that performs a specific task and can be called from within SQL statements. A function can accept input parameters and return a value.

To create a function in SQL that returns stu_Name when passed stu_ID, you can use the following syntax:

CREATE FUNCTION get_student_name (student_id INT) 
RETURNS VARCHAR(50) AS 
BEGIN  
DECLARE student_name VARCHAR(50);  
SELECT stu_Name INTO student_name FROM students WHERE stu_ID = student_id;  
RETURN student_name; 
END;

This function is called get_student_name and takes one input parameter student_id of type integer. It returns a value of type VARCHAR(50), which is the name of the student whose ID matches the input parameter.

The function uses a local variable student_name of type VARCHAR(50) to store the name of the student retrieved from the database table students based on the input parameter value student_id. Finally, the function returns the value of student_name.

You can then call this function in a SQL statement like this:

SELECT get_student_name(12);

This will return the name of the student with ID 12.

forum

What is a function in SQL? Create a function that returns stu_Name when passed stu_ID.

Can you answer this question?

1 Answers