ExamNotes.net  -  IT certification portal

ForumsCertResearchTop sitesNewslettersFree email
HomeRegister
Exams Notes
Practice exams
Exam games
Questions by email
Online training
Training videos
College degrees
Boot camps
Book store
Links directory
Tell a friend
For webmasters

CompTIA Exam Vouchers
Save money on CompTIA exams
Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more

* ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i

Online practice tests

Certification sites

Online university

Online college

Online education

Distance learning

Software forum

Server administration forum

Programming resources






This is interesting: Free IT Magazines | Databases help forum



General discussions > Public newsgroups > microsoft.public.sqlserver.server > Calling a Stored proc within a stored proc

Show a Printable Version
Email This Page to Someone!
Receive updates to this thread






Author Calling a Stored proc within a stored proc
Prakash Dharan
Guest




Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A
Calling a Stored proc within a stored proc


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."



Report this post to a moderator

Old Post 06-27-02 09:25 AM
Reply w/Quote Edit/Delete Message IP: Logged

Guest




Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A
Re: Calling a Stored proc within a stored proc

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."
>
>
>



Report this post to a moderator

Old Post 06-27-02 10:25 AM
Reply w/Quote Edit/Delete Message IP: Logged
Prakash Dharan
Guest




Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A
Re: Calling a Stored proc within a stored proc

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."
>
>
>



Report this post to a moderator

Old Post 06-28-02 02:25 AM
Reply w/Quote Edit/Delete Message IP: Logged
All times are GMT.
Post new thread   Post reply

Featured site: MCSE, MCSD, CompTIA, CCNA training videos



Forum Jump:
Rate This Thread:
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF.
 

ExamNotes forum archive


Powered by: vBulletin 2.2.8
Copyright ©2000, Jelsoft Enterprises Limited.

  Free Braindumps | mcse braindumps