Click here to Skip to main content

15,886,776 members

Sign in

Sign in

Email

Password

Forgot your password?

Sign in with

home
articles
quick answersQ&A
discussionsforums
featuresfeatures
communitylounge
help?

Search within:
Articles
Quick Answers
Messages

Use my saved content filters

All Questions All Unanswered FAQ

Can two procedures be called in a single procedure ?

Please Sign up or sign in to vote.

0.00/5 (No votes)

See more:

Can two procedures be called in a single procedure ?

Posted 8-Jul-13 21:24pm

jitendra kachhi

2 solutions

Top Rated
Most Recent

Please Sign up or sign in to vote.

Solution 2

Accept Solution Reject Solution

Yes... Procedures can be called into a Procedure... I Have called seven Procedures into a Procedure...

Example:

SQL

Alter Proc Procedure1 @Param1 Nvarchar(40)
as 
Begin
   Exec Procedure2 'InputParameter'
   Exec Procedure2 @Param1
End

Share this answer

Posted 8-Jul-13 21:36pm

Comments

Maciej Los 9-Jul-13 3:41am

Good example!
+5!

Raja Sekhar S 9-Jul-13 3:53am

Thank you.. Maciej Los...

jitendra kachhi 9-Jul-13 4:00am

Thanks Raja sekhar s

Raja Sekhar S 9-Jul-13 4:07am

You are Welcome.... if the answer is helpful... u can accept it as Answer...

jitendra kachhi 9-Jul-13 8:04am

can we use multiple catch with single try in sql server ?

Raja Sekhar S 10-Jul-13 0:56am

No, In Transact-SQL, each TRY block is associated with only one CATCH block.
Refer to this link:
http://msdn.microsoft.com/en-us/library/ms179296(v=sql.105).aspx

Please Sign up or sign in to vote.

Solution 1

Accept Solution Reject Solution

Yes of course you can call procedure during other procedure execute.
Refer this link to see how to do this:

http://stackoverflow.com/questions/170328/executing-a-stored-procedure-within-a-stored-procedure[^]

http://www.dbforums.com/db2/1642603-how-call-one-procedure-another-procedure-select-block.html[^]

Share this answer

Posted 8-Jul-13 21:31pm

Add a Solution

Add your solution here

Plain Text

ASM

ASP

ASP.NET

BASIC

BAT

C#

C++

COBOL

CoffeeScript

CSS

Dart

dbase

F#

FORTRAN

HTML

Java

Javascript

Kotlin

Lua

MIDL

MSIL

ObjectiveC

Pascal

PERL

PHP

PowerShell

Python

Razor

Ruby

Scala

Shell

SLN

SQL

Swift

T4

Terminal

TypeScript

VB

VBScript

XML

YAML

OKPaste as

Strip HTML

Encode HTML

Paste as-is

Code block

Quoted Text

Best guess

To display as

The content must be between 30 and 50000 characters.

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

Submit your solution

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Top Experts

Last 24hrs

This month

Pete O'Hanlon	60
Richard MacCutchan	55
Graeme_Grant	25
Wonde Tadesse	10
Andre Oosthuizen	10

Pete O'Hanlon	2,305
OriginalGriff	1,683
Graeme_Grant	1,150
Richard Deeming	893
Dave Kreskowiak	839

Related Questions

Sql stored procedure not releasing from .NET

calling procedures of oracle

writing a single stored procedure for two queries

call two procedures using select statement

Executing multiple stored procedure within single block

Convert oracle procedure to SQL server procedure and give SQL server procedure?

Single Stored Procedure for Multiple Database

Can't call two stored procedures

want to insert a single row in a procedure

How to call multiple procedure within a single function ? Please help!

Advertise
Privacy
Cookies
Terms of Use
Last Updated 9 Jul 2013

Layout: fixed | fluid

Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900