|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Calling a Stored proc within a stored proc
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calling a Stored proc within a stored proc
|
|
| Prakash Dharan 2002-06-27, 4:25 am |
|
Please send me some samples or reference sites on how I can call a Stored
procedure within a stored procedure.
Thanks in advance
--
Regards
Prakash Dharan
FXA Software Technology (I) Pvt. Ltd.,
Chennai. India
Phone : 91 - 44 - 2200928
"Count your life by smiles, not tears. Count your age by friends, not
years."
| |
|
| Within the stored procedure, add the following command:
exec my_sp_name @parameter1 = a_value,@parameter2 = a_value etc
_____________________
Join and Promote your skills at http://www.ciquery.com
"Prakash Dharan" <dharan_p@hotmail.com> wrote in message
news:eFp36GcHCHA.2144@tkmsftngp13...
>
> Please send me some samples or reference sites on how I can call a Stored
> procedure within a stored procedure.
>
> Thanks in advance
> --
> Regards
> Prakash Dharan
> FXA Software Technology (I) Pvt. Ltd.,
> Chennai. India
> Phone : 91 - 44 - 2200928
>
> "Count your life by smiles, not tears. Count your age by friends, not
> years."
>
>
>
| |
| Prakash Dharan 2002-06-27, 9:25 pm |
| My case if the stored procedure returns a set of records or just one record.
Can I open a cursor with a storedprocedure in this case ?
Please advice..
--
Regards
Prakash Dharan
FXA Software Technology (I) Pvt. Ltd.,
Chennai. India
Phone : 91 - 44 - 2200928
"Count your life by smiles, not tears. Count your age by friends, not
years."
"Prakash Dharan" <dharan_p@hotmail.com> wrote in message
news:eFp36GcHCHA.2144@tkmsftngp13...
>
> Please send me some samples or reference sites on how I can call a Stored
> procedure within a stored procedure.
>
> Thanks in advance
> --
> Regards
> Prakash Dharan
> FXA Software Technology (I) Pvt. Ltd.,
> Chennai. India
> Phone : 91 - 44 - 2200928
>
> "Count your life by smiles, not tears. Count your age by friends, not
> years."
>
>
>
|
|
|
|
|