Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

store procedure

Home
Forums
C#

store procedure

Chandu Kumawat

Chandu Kumawat

10yAsked Dec 9, 2015, 1:14 AM908C#

multiple store procedure in one procedure plz give any example

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Manas Mohapatra10y ago
I am assuming that you are using SQLServer, if so here is the code:

Main Procedure(It will call other StoredProcs)

CREATE PROCEDURE [dbo].[usp_AddNewRecord]
(
   @AssetID AS INT
)
AS
BEGIN
SET NOCOUNT ON;
   EXEC usp_AddInTemp1 @AssetID;
   EXEC usp_AddInTemp2 @AssetID;
END;

Definition of usp_AddInTemp1

CREATE PROCEDURE [dbo].[usp_AddInTemp1]
(
   @AssetID AS INT
)
AS
BEGIN
SET NOCOUNT ON;
    -- Implement your logic
END;

Definition of usp_AddInTemp2

CREATE PROCEDURE [dbo].[usp_AddInTemp2]
(
   @AssetID AS INT
)
AS
BEGIN
SET NOCOUNT ON;

   -- Implement your logic
END;
Raja T10y ago
Hello Chandu, Try like

sp1:
create proc addn(@a float, @b float)
as
begin
declare @sum varchar(4)
set @sum=cast((@a+@b) as VARCHAR)
print @sum
END

sp2:
create proc subn(@a float, @b float)
as
begin
declare @sub varchar(4)
set @sub=cast((@a-@b) as VARCHAR)
print @sub
END

sp3:
create proc calc(@a float, @b float)
as
begin
declare @tot varchar(10)
exec addn @a,@b
exec subn @a,@b
END

Checkout put like
exec calc 50,40
Results
90
10
Francis Susaimichael10y ago
Can you add some more clarity on your question?