USE [数据库名称]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[存储过程名称]
(
@参数名称1 char(20),
@参数名称2 数据类型(长度)
)
as
begin
--定义变量: declare @变量名称 数据类型(长度)
declare @V_Hospitalized char(2)
--IF语句 变量赋值
if (@In_PatType = '1')
begin
set @V_Hospitalized = 'N'
end
if ( @In_PatType = '2')
begin
set @V_Hospitalized = 'Y'
end
SELECT
*
FROM [数据库名称].[dbo].[表名] s
where s.Hospitalized = @V_Hospitalized
and s.studyid = @in_ReportId
end;
GO