สร้าง Create Stored Procedure การสร้าง Stored Procedure บน SQL Server Database

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE SearchStudent 
	-- Add the parameters for the stored procedure here
	@student_code varchar(10) =''
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	-- Insert statements for procedure here
	SELECT 
	    [student_code]
      ,[student_Tfullname]
      ,[student_Tlastname]
      ,[student_Efull_name]
      ,[student_Elast_name]
      ,[student_status]
      ,[student_faculty] 
   FROM dbo.tbl_student
   WHERE [student_code] LIKE '%' + @student_code + '%'
   
END
GO