Stored Procedures, database Stored Procedures

Stored Procedures, database Stored Procedures

Use yuyongTest;

Go

 

-- Define a stored procedure and input an int parameter to this stored procedure. This stored procedure will assign a value (as a result) to a parameter of the nvarchar (50) type)

Create procproc_getStudentName (@ numint, @ namenvarchar (50) out)

As

Select @ name = namefrom student where number = @ num;

Go

-- Defines a variable of the nvarchar (50) type and accepts the value assigned by this stored procedure (equivalent to the returned result)

Declare @ getName nvarchar (50 );

-- Execute the stored procedure and input parameters and variables that need to receive results.

Exec proc_getStudentName62, @ getName out;

Select @ getName;

 

Select * from student where number = 62

 

The result is as follows: