SQL Server 17 - ON DELETE and ON UPDATE

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[SamuelLing]

i have a use case for default, though, it doesn't seems to be related to this video

i use default for the user power in the usertable, i used it to differentiate between normal user, moderator and admin, like for example 0 = normal user, 1 = moderator and 2 = admin, so the default i put 0 since, it should be assigned to all user once they created their account

[ntigirishari]

Thank you so much, Caleb!! You're a good teacher!!

[rungxanh]

You saved me the headache of sticking to my professor's awful lecture on this very topic 🥰

[HindiLearnersDiary]

Just great videos. Please keep them coming. I watch every day. Your style of delivering this info is very clear and easy to understand.

[JP-tdgt]

Wuzz up everyone! 👍 thank you for the explantion. Shout out from Arizona.

[rookiecookie]

you been a life saver throught my database principles in college <3

[Mahadonation]

thanks for the help, hopefully your lungs aren't set to null

[ashishpant]

Yeah I thought she default is about for anonymous one

[zvit]

Great stuff! Question... if you have CASCADE set on a UNIQUE FK and try to change the value of the FK (on UPDATE) to a value that exists already in the table... will the UNIQUE attribute still kick in and not allow this, even though you have it set to Cascade? (makes sense that it would but I wanted to ask).

[pxjqbmt]

its better if your references always add arrow, anyway still a great series

[kman]

I'm guessing that referring to views as morons has greatly impacted people's desire to watch more... Catch more flies with sugar. . you can cascade the rest of that...