how to insert the deleted data in another table simultaneously using stored procedure

Question

0.00/5 (No votes)

See more:

In the interview I was asked a question:

Two tables are given I need to delete a data from one table and simultaneously add it in another table using Stored Procedure.

How to do it.

Posted 22-Feb-15 18:14pm

Member 11043260

Add a Solution

2 solutions

Solution 2

The question was specific: 'delete a data from one table and simultaneously add it in another table !!! only through Stored Procedure !!!'. So you have to build a dynamic function which is able to conduct a set of operation (in a broader sense not only INSERT or DELETE) on multiple tables.

So you have to use SP, local variable, Transaction; I mean a dynamic process for this. Follow the link and "solution 4", it will be helpful. This is a basic example of UPDATE only. You can include INSERT and DELETE also.
Thank You.
How to make 1 column in two table and, if we change in one , another change automatically[^]

Posted 22-Feb-15 19:56pm

Alam_Orko

Updated 22-Feb-15 19:58pm

v2

Add a Solution

Add your solution here

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

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)

Wendelius · Accepted Answer · 2015-02-22T18:24:00

Solution 1

This can be done in numerous ways. One way would be to use the OUTPUT clause[^] and get the deleted rows into a table variable and then insert that into another table. Another possibility would be to utilize deleted table[^] inside a trigger. Of course a simple INSERT INTO ... SELECT structure before the deletion could also be an option.

However, to be precise, none of these are simultaneous.

Posted 22-Feb-15 18:24pm

Wendelius

Updated 22-Feb-15 18:27pm

v3

Comments

King Fisher 23-Feb-15 1:29am

very nice my 5.

Wendelius 23-Feb-15 14:13pm

Thank you !

Santosh K. Tripathi 23-Feb-15 2:11am

5+

Wendelius 23-Feb-15 14:13pm

Thanks !