Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL In and Out parameters
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


pratap
In and Out parameters
1 Answer(s)      5 years and 3 months ago
Posted in : SQL



Advertisement
View Answers

September 22, 2009 at 3:24 PM


Hi Friend,

Stored Procedures are basically used for passing values and receiving values.It is having three parameters-IN,OUT,INOUT.

1)IN: It is default parameter which is passed to the procedure and can change inside the procedure, but remains unchanged outside.

2)OUT: This parameter does not supply any value to the procedure.It is assumed to be NULL, but it can be modified inside the procedure, and is available outside the procedure.

Try this to add two numbers:

DELIMITER $$
CREATE PROCEDURE pr3(IN in_count INT,IN in1_count INT)
BEGIN
DECLARE num INT;
SET num =in_count + in1_count;
SELECT num;
END$$
call pr3(5,5);

Thanks


Related Tutorials/Questions & Answers:
In and Out parameters - SQL
In and Out parameters  What are in and out parameters in stored... parameters-IN,OUT,INOUT. 1)IN: It is default parameter which is passed... no's and get output using parameters in MySql  Hi Friend, Stored Procedures
supplying values to in parameters of stored procedure in ms sql and displaying out parameters
supplying values to in parameters of stored procedure in ms sql and displaying out parameters  I have to execute following procedure ALTER PROCEDURE [dbo].[get_date] @codeId int, @vardate as datetime OUTPUT AS SELECT
Advertisements
How do I find out the number of parameters passed into function9. ?
How do I find out the number of parameters passed into function9. ?  How do I find out the number of parameters passed into function9
error:Parameter index out of range (1 > number of parameters, which is 0).
error:Parameter index out of range (1 > number of parameters, which is 0).  my code:String org=request.getParameter("Org"); String desg=request.getParameter("des"); String From=request.getParameter("From"); String
the number of parameters
the number of parameters  How do I find out the number of parameters passed into function
SQL IN Parameters
SQL IN Parameters       A parameter is a placeholder that accept a user-defined value, whenever... This Example shows you how to use in type parameters. The Tutorial illustrates
named parameters vs postional parameters - Hibernate
named parameters vs postional parameters  hi,Can you please explain why we i should go for particular parameters or positional parameter... regards, somasekhar
measuring Qos parameters
measuring Qos parameters   Hi, is there a tool for measuring the quality of service (Qos) of an web services. Thanks
measuring Qos parameters
measuring Qos parameters   Hi, is there a tool for measuring the quality of service (Qos) of an web services. Thanks
Access web.xml init parameters
Access web.xml init parameters  How to access web.xml init parameters from java code
JSP-parameters possible ways
JSP-parameters possible ways  In a JSP program called books.jsp, the Java code out.print(request.getParameter(‚??number‚??)); displays ‚??1111111‚??. What are the ways for the parameter number to have got its value
JSP-parameters possible ways
JSP-parameters possible ways  In a JSP program called books.jsp, the Java code out.print(request.getParameter(‚??number‚??)); displays ‚??1111111‚??. What are the ways for the parameter number to have got its value
parameters - JSP-Servlet
example with sending parameters with hyperlibk in srevlets to jsp.. Thanqs advnce
Passing Parameters - JSP-Servlet
to forward the parameters through click of button **/ On this page I have
how to debug parameters in the hibernate query
how to debug parameters in the hibernate query  how to debug parameters in the hibernate query
Explain the parameters of Font class constructor.
Explain the parameters of Font class constructor.  Explain the parameters of Font class constructor.   Java Font class: Font(String name... and point size. Parameters: name - the font name. This can be a logical font name
Passing parameters in JSP using forward.
Passing parameters in JSP using forward.  If a page is forwarded to another page using jsp:forward, is it necessary that the page should be already............   Pass Parameters using jsp:forward
Passing Parameters in jsp
Passing Parameters in jsp       This section illustrates you how to pass parameters in jsp. JSP can... for retrieving parameter values by name. Parameters can be passed by using a tag <jsp
log out
log out  how do i create a log out on a project without it exiting system so it does not reload again
Is there anyone out there?
Is there anyone out there?  Hi please could somebody respond as I am seeking advice but not getting any and do not know whether or not to continue using this site
url parameters displayed in short sentence
url parameters displayed in short sentence  In my url parmeter like below http://127.0.0.1:7778/project/preview.jsp.codesvr=127.0.0.1:9997&id="1" It will displayed the value of id=1 ... I want to change this url
Request Parameters in JSP
Request Parameters in JSP   ... parameters. HttpServletRequest interface is responsible for providing request parameters. Request Parameters are the data sent from client to the server side
Request Parameters In EL
Request Parameters In EL     ... to read the parameters from the file. If we have multiple values to read from... to retrieve the parameters in EL   The code of the program is given below
Pass parameters from JSP to Servlet
Pass parameters from JSP to Servlet In this section, you will learn how to pass parameters from JSP page to servlet. For this purpose, we have used... { ServletOutputStream out = res.getOutputStream(); String name
Passing parameters to XSLT style sheets
Passing parameters to XSLT style sheets       Passing parameters to XSLT style sheets... display, The xml and xsl is passed as parameters to the function '
Passing Parameters using <jsp: param>
Passing Parameters using <jsp: param>          Request parameters can... a string literal as a value. These parameters are evaluated at request time. 
Can anybody tell me how to use #parameters in struts 2 ?
Can anybody tell me how to use #parameters in struts 2 ?  I have a login page, And by using struts.xml and #parameters I want to display error.../Login.jsp Its urgent. Pl help me out
Velocity Macro with Parameters
Velocity Macro with Parameters       This Example shows you how to use macro with parameters in velocity  template. Example given below show you, how
Applet Tag Parameters,Applet Tag in HTML
<APPLET> Tag Parameters: The <PARAM> Tag       These are the parameters passed directly to a Java applet. Parameters are to applets what command-line
&lt;APPLET&gt; Tag Parameters: The &lt;PARAM&gt; Tag
<APPLET> Tag Parameters: The <PARAM> Tag       These are the parameters passed directly to a Java applet. Parameters are to applets what command-line
SQL database parameters should save at where?
SQL database parameters should save at where?  Hi, Currently the information regarding the SQL databases are hard coded into the script, Assuming... parameters to the file and read using JAVA I/O and allow user to edit the file
 

 

 

DMCA.com