SQL database Stored Procedures

Stored procedure: Just like a function
stored in the database--"programmability--" storage procedures
-----------------------------------------------------
To create a stored procedure:
Create proc Jiafa
--Required parameters
@a int,
@b int
As
--contents of the stored procedure
declare @c int;
Set @c = @a + @b;
return @c;
Go

--Select all after execution, execute create
-----------------------------------------------------
To execute a stored procedure:

declare @f int;
exec @f = Jiafa 3, 5;
Print @f;

--Query the number of cars that meet this condition according to the parameters passed by the user
Create proc Chaxun
@n varchar (20)
As
DECLARE @num int
Select @num = count (*) from car where name like '% ' [email protected]+ '% '
Return @num
Go

DECLARE @m int
exec @m = Chaxun ' Audi '
Print @m

SQL database Stored Procedures