Updating existing records in a dataset

Source(Employee ID int, Employee Name varchar(10), CONSTRAINT Source_PK PRIMARY KEY(Employee ID)); GO INSERT dbo.Target(Employee ID, Employee Name) VALUES(100, 'Mary'); INSERT dbo.

updating existing records in a dataset-21

EPA does not sell or otherwise transfer personal information to an outside third party.

[Federal Register: March 18, 2002 (Volume 67, Number 52)][Page 12010-12013].

Otherwise,you might specify the additional search criteria in a way that produces incorrect results.

Rows in the source are matched with rows in the target based on the join predicate specified in the ON clause. One insert, update, or delete operation is performed per input row.

This Data Wrangling Handbook recipe looks at six common ways that a dataset is ‘dirty’ and walks through time-saving ways you can use a spreadsheet to fix them and ‘clean’ the dataset.

Last modified 12-Dec-2016 03:51