Duration: 15:32 min
Summary: In this video, we will shift from the select statement to data modifications. After all, T-SQL gives the user the ability to change data in the tables. Sometimes, we need to update a person’s address, or remove a customer that does not exist. We will look at different ways of inserting data into the tables (insert values, insert select, and insert into). We will also see how we can update existing data, and delete records. Since the change we are making is permanent, I will show you couple of tricks to use to make sure that you do not unintentionally delete records. Finally, we will see how we can quickly delete all the records in the table using ‘Truncate’. This operation is faster than delete because there is no logging with truncate.