[SQL] Update and Alter

preview_player
Показать описание
We will go over 3 different ways to update data: (1) Hard Coding, (2) Reference a work table for multiple updates, and (3) Insert and Update across different databases in the same SQL server. We will also go over a few different ways to use Alter to change the table itself.

🔴 IF YOU WANT THE CODE: 🔴
The file name will match the YouTube title name for the corresponding video.

🔗 Other Links

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

🖐Hi! I'm VeeBee, you can call me VB or Bee for short! Over the years during my career I have been keeping a journal of what I have learned when working in different languages and projects.

🏁 My goal is to pass along what I have learned to you by teaching through projects and exercises based on real world experiences.

✨ My promise to you is that I will do my best to not waste time. Each video will have a full summary at the very beginning so that you can determine if you can skip the video if you already know the material, or the summary can be a refresher if you're coming back.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

Tips are never expected, but always appreciated! I plan on creating content regardless, so there is no pressure or obligation to donate.
Рекомендации по теме
Комментарии
Автор

Timestamps:
1) Explaining data type with Identity(1, 1) 3:20
2) Update Method 1: Hard Coding 11:15
3) Update Method 2: Using a Work Table for multiple updates 15:17
4) Update Method 3: Working between Databases 21:18
4a) Insert data from a different database, from same server 24:21
4b) Update data from a different database, from same server 29:35
5) Alter 31:46

veebeecoding