Home > DeveloperSection > Interviews > How to use Procedure in SQL?

Posted on    September-30-2016 7:18 AM

 MYSQL SQL Server  SQL  SQL Server 2008 
Ratings:
 1 Answer(s)
  113  View(s)
Rate this:

Abhishek Srivasatava
Abhishek Srivasatava

Total Post:70

Points:350
Posted on    September-30-2016 7:18 AM

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

Don't want to miss updates? Please click the below button!

Follow MindStick