74-100 sql存储过程 创建与执行

  

    无参数的存储过程创建 

  

USE [Learn]
GO
/****** Object:  StoredProcedure [dbo].[SCO_bav]    Script Date: 2021/12/24 星期五 11:53:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

 


 --
ALTER PROCEDURE [dbo].[SCO_bav] 
     
AS
BEGIN

     select * from demo01 where sex='女' and sg=165;

     
END

 效果：