Breaking News: Grepper is joining You.com. Read the official announcement!

insert update sql server

Fabien Duc answered on October 24, 2022 Popularity 7/10 Helpfulness 1/10

answer insert update sql server

insert update sql server

Comment

--MERGE SQL statement - Part 1

--Create a target table
CREATE TABLE Products
(
   ProductID INT PRIMARY KEY,
   ProductName VARCHAR(100),
   Rate MONEY
) 
GO

--Insert records into target table
INSERT INTO Products
VALUES
   (1, 'Tea', 10.00),
   (2, 'Coffee', 20.00),
   (3, 'Muffin', 30.00),
   (4, 'Biscuit', 40.00)
GO

--Create source table
CREATE TABLE UpdatedProducts
(
   ProductID INT PRIMARY KEY,
   ProductName VARCHAR(100),
   Rate MONEY
) 
GO

--Insert records into source table
INSERT INTO UpdatedProducts
VALUES
   (1, 'Tea', 10.00),
   (2, 'Coffee', 25.00),
   (3, 'Muffin', 35.00),
   (5, 'Pizza', 60.00)
GO

SELECT * FROM Products
SELECT * FROM UpdatedProducts
GO

Popularity 7/10 Helpfulness 1/10 Language sql

Source: www.mssqltips.com

Tags: insert-update sql sql-server

Link to this answer
Share Copy Link

Contributed on Oct 24 2022

Fabien Duc

0 Answers Avg Quality 2/10

insert update sql server

Contents

More Related Answers

insert update sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.