<

SQL - Updating and Deleting Data

Posted on
6,685 Points
285 Views
4 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:36
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.

Video Steps

1. Make a table

2. Update a specific column given a specific row using the UPDATE statement

3. Remove a set of values using the DELETE statement

4
Author:Zia Syed
0 Comments
I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month