Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Need Help with insert and update using sql server 2005

    drop table Products --Target Table)

    drop table UpdatedProducts--Source Table --Update records

    --Create a target(Destination) table

    CREATE TABLE Products

    (

    ProductID INT PRIMARY KEY,

    ProductName VARCHAR(100),

    Rate MONEY

    )

    GO

    --Insert records into target(Destination) table

    INSERT INTO Products VALUES

    (1,...

Viewing post 1 (of 1 total)