How to declare variables in SP?

I am learning SQL server. When I am trying to learn stored procedure I have raised one queri that is How to declare variables in SP?

For example I have created on stored procedure as given below:-
CREATE procedure emp_DebugA
(
@IntIn int,
@IntOut int OUTPUT
)
as

Set @IntOut = @IntIn + 10

Return

and then I have typed command is
Declare @NewInt int

then I have typed command is
exec emp_DebugA 5,@NewInt OUTPUT - when I am executing this command it is showing errror msg like "Must declare the variable '@NewInt'."

please find the details of [URL="http://databases.about.com/od/sqlserver/a/storedprocedure.htm"]stored procedures here[/URL].

hi
stored procedore usually contains a set of SQl command to be executed.u try out with some SQL COMMANDS

U CAN excute a stored procedure as


declare @a int (all input variable)
set @a=5(giv input for all the varibles)
exec <Stored Procedure name> (all inpu variable & output variables.output variables should be hav output key word)

hi,
bharathi ur SP is perfectly right, i just copied and excuted in query analyser and it worked perfectly fine.. i hope after creating the SP :
***********
CREATE procedure emp_DebugA
(
@IntIn int,
@IntOut int OUTPUT
)
as

Set @IntOut = @IntIn + 10

Return
***********
and while exceuting the commnad below:
*************
Declare @NewInt int
exec emp_DebugA 5,@NewInt
*************
u have taken both the lines into account. if u havent then only it would give such an error.

Hi Bharati_ark,

The error is in the "exec" line of your coding.....

Execute the Stored Procedure as given below and try:

[COLOR="Navy"][B]Declare @NewInt int
exec emp_DebugA 5 , @IntOut=@NewInt output
print @NewInt [/B][/COLOR]


Best Wishes
Sreedevi
:)