How to use Procedure in SQL?

Abhishek Srivasatava 2045 30 Sep 2016

Abhishek Srivasatava

Employee

1 Answers

Abhishek Srivasatava 30 Sep 2016

Simple way to learn about the Procedure:

Procedure is a group of SQL statement.

Syntax for the procedure

CREAT PROCEDURE PROC1
(
          NUM1           INT
)
AS
BEGIN
          IF( NUM1>100)
             BEGIN
                      PRINT ‘PASS’
             END
          ELSE 
              BEGIN
                        PRINT ‘FAIL’
             END
END

How to use this concept in programming?

As it is widely used in most of the application. So one should aware about this concept practically.

Suppose we have insert command from the user side then first we need to verify is that upcoming data is already exist or not.

Here is the small program for the above example:

CREATE PROCEDURE Proc_Info
(
@PRSN_INTN_ID INT,
@EMPL CHAR (20),
@NAME CHAR (20),
@REFERENCE INT
)
 
AS
BEGIN
 
         IF NOT EXISTS (SELECT PRSN_INTN_ID FROM EE_EMPL_CAT1 WHERE
                                PRSN_INTN_ID = @PRSN_INTN_ID)
                     BEGIN
                               INSERT INTO EE_EMPL_CAT1 (PRSN_INTN_ID,[EMPL_STAT_CD],[NAME],REFERENCE_id)
                                VALUES (@PRSN_INTN_ID,@EMPL,@NAME,@REFERENCE)
                     END
         ELSE
                     BEGIN
                               PRINT 'DATA ALREADY EXISTS'
                     END
END

interview

How to use Procedure in SQL?

Can you answer this question?

1 Answers