SQL IN Parameters

A parameter is a placeholder that accept a user-defined value, whenever stored procedure is executed.

Understand with Example

This Example shows you how to use in type parameters. The Tutorial illustrates an example, which create a procedure 'abc' and accept input parameter. The input parameter allows the invoker to pass the data into the procedure. 

Create Procedure

delimiter $$

create procedure abc(IN a int)
BEGIN 
	SET @x = a;
END$$
delimiter ;

Call Procedure

call Procedure name is used to execute the procedure.

call abc(123);

Fetch variable value

Fetch Variable (@value) return you the value of parameter in the Query.

select @a;

Result

+------+
| @x   |
+------+
| 123  |
+------+

Related Tags for SQL IN Parameters:
c,  user,  exec,  value,  parameter,  exe,  define,  execute,  to,  ram,  store,  ld,  proc,  e,  procedure,  placeholder,  use,  ce,  in,  m,  par,  ace,  me,  pro,  param,  accept,  cut,  defined,  stored,  tor,  when,  s,  user-defined,  xe,  at,  old,  is,  ha,  meter,  du,  ar,  cc,  whenever,  va,  s,  s,  roc,  th,  st,  alu,  hat,  fin,  holder,  pl,  pr,  ol,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: SQL IN Parameters  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):