Want to copy records of one column from table to another table in the same database

Question

1.00/5 (1 vote)

See more:

I have column named as 'SubmittedBySchool' in the table named 'SignOff'. The records under these columns have the date entered dynamically as and when the user clicks on the submit button in the web page. Now I want the data under this column to be copy to the column named 'DateTravelPlanSubmitted' in the table 'School' and also the data must be changed automatically in both the column each time the user clicks on the submit button. Can anyone help me to perform this task.

Posted 28-May-15 3:19am

user 3008

Updated 29-May-15 1:35am

v3

Add a Solution

Comments

F-ES Sitecore 28-May-15 9:43am

Use the INSERT INTO .. SELECT command. Google "t-sql insert into" if you don't know how to use it.

Advay Pandya 28-May-15 9:55am

I have a query on this. You want to copy data from one to another table. So the data will be inserted every time ? or the data will be inserted and updated both based on situation ?

user 3008 28-May-15 10:14am

update the data of the column DateTravelPlanSubmitted to the table Schools each time it changes in the SignOff table. This update must be automatically

ZurdoDev 28-May-15 13:18pm

1. Reply to the comment so that the user is notified.
2. Use triggers. Google for examples.

Nelson Belmont 28-May-15 10:41am

Have you tried using triggers?

2 solutions

Solution 1

Create a trigger for INSERT, Update and Delete on table 'School' and write below query

Insert Into School(
[DateTravelPlanSubmitted]
)
Select
SO.[SubmittedBySchool]
From
SignOff SO

Posted 28-May-15 20:21pm

kaushikpathak

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)

Advay Pandya · Accepted Answer · 2015-05-29T01:01:00

Solution 2

Hi,

As per my understanding you want to update column "DateTravelPlanSubmitted" of the table "Schools" whenever data of "SignOff" table is updated.

If this is correct then you can create a trigger on update

SQL

CREATE TRIGGER Trigger1
   ON  SignOff
   AFTER UPDATE
AS
BEGIN

    Update Schools  SET DateTravelPlanSubmitted = [Your Value]
         from inserted
    WHERE Schools.PremaryKey = inserted.Primarykey

END

Please let me know of you have different requirement then I understood or you want more information.

Thanks
Advay Pandya

Posted 29-May-15 1:01am

Advay Pandya

Comments

user 3008 29-May-15 7:33am

Sorry about that. I want the this updating to be done using ASP.NET code, so that this will data will be copied to the table Schools each time it is been changed in the website.

Advay Pandya 1-Jun-15 1:53am

Hi, yes.. If you set trigger then no matter from where are you updating the table it will be reflected. Whenever your table is updated the trigger will fire and it will update another table accordingly. If you are updating the table using ASP.Net still the trigger will update another table automatically. Please let me know if you need more info on this.

user 3008 2-Jun-15 12:13pm

Thank you so much for the solution. It is now working perfectly. :-) :-)

Advay Pandya 3-Jun-15 2:04am

Always Welcome :)