Post reply

Updating Database

  • July 11, 2002 at 7:42 am

    #357569

    I have a customer who is entering data in one table in a database and they want to update a table in a other database .

    Using SQL Server 2000. They want to enter the data only once . What is the best way to do this.

  • July 11, 2002 at 7:46 am

    #432466

    Use a trigger and look at the insert table. There you can inset to the other table based on the insert input on the one table. See CREATE TRIGGER in BOL.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply