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.

How to create a single SP using multiple tables

Home
Forums

How to create a single SP using multiple tables

Chittaranjan Swain

Chittaranjan Swain

6yAsked Nov 5, 2019, 8:35 PM3.4k

Hi all, How to create a single stored procedure using multiple tables with multiple work.

2 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

Mageshwaran R6y ago
HI,
try this code:
CREATE PROCEDURE PR_NAME
AS
BEGIN
BEGIN
CREATE TABLE TABLE_NAME1(FIRSTNAME NVARCHAR(50),LASTNAME NVARCHAR(50),ID INT)
END
BEGIN
CREATE TABLE TABLE_NAME2(FIRSTNAME NVARCHAR(50),LASTNAME NVARCHAR(50),ID INT)
END
END
EXEC PR_NAME
Jefferson S. Motta6y ago
look at:

https://www.c-sharpcorner.com/article/how-to-create-a-stored-procedure-in-sql-server-management-studio/

but for multiples tables you need use JOIN, look at:

https://stackoverflow.com/questions/24048279/creating-a-stored-procedure-with-multiple-nested-begins

to use multiples BEGIN END :
CREATE PROCEDURE procCreateCarTable
IS
BEGIN
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE CARS';
    EXCEPTION WHEN OTHERS THEN NULL;
    EXECUTE IMMEDIATE 'CREATE TABLE CARS (ID VARCHAR2(1), NAME VARCHAR2(10), TITLE
    VARCHAR2(10))';
END;
BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE TRUCKS';
    EXCEPTION WHEN OTHERS THEN NULL;
    EXECUTE IMMEDIATE 'CREATE TABLE TRUCKS (ID VARCHAR2(1), NAME VARCHAR2(10), TITLE
    VARCHAR2(10))';
END;
END;