In Transact-SQL (T-SQL) UPDATE allows us to change the existing data in a table. This lab is divided into seven exercises explaining different ways to update the data. In first exercise we will learn to update a column data using string functions. In second exercise we will learn to update multiple columns for multiple rows at once. In third exercise we will learn to update the rows based on JOIN. In fourth exercise we will learn to update rows based on correlate subquery. In fifth exercise we will learn to update a portion of data for large data types.
Exercise 1: UPDATE a column data using String Functions
Exercise 2: UPDATE multiple columns for multiple rows at once
Exercise 3: UPDATE the rows based on JOIN
Exercise 4: UPDATE rows based on correlated subquery
Exercise 5: UPDATE a portion of data for large data types
Exercise 6: Self-Assessment
Exercise 7: T-SQL Challenge
Reviews
There are no reviews yet.