For this Stored Proc, Declare the Scalar variable 'Person_ID" in mssql

Go

CREATE PROC dbo.PROC_PERSON_ID (

@ADMIS_ID INT= NULL,

@PERSON_ID INT (5) = NULL,

@DOCTOR_ID INT (5)= NULL,

@ADMIS_DATE DATE NOT NULL,

@DISCH_DATE DATE = NULL

)

AS

BEGIN

SET NOCOUNT ON

INSERT INTO HOSP_ADMIS( ADMIS_ID, PERSON_ID,DOCTOR_ID,ADMIS_DATE, DISCH_DATE )

VALUES (@ADMIS_ID,@PERSON_ID, @DOCTOR_ID, @ADMIS_DATE,@DISCH_DATE );

END

GO