HOW TO USE PROCEDURE IN SQL?

Abhishek Srivasatava

Total Post:70

Points:350
Posted by  Abhishek Srivasatava
 348  View(s)
Ratings:
Rate this:
  1. Abhishek Srivasatava

    Post:70

    Points:350
    How to use Procedure in SQL?

    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
     

     

      Modified On Oct-05-2016 07:49:23 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!