Adding a default constraint - Part 4

In this video we will learn, how to specify a column default using a default constraint

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[deepakdewaly]

One of the best online tutorials I have ever gone through. It feels like a face to face class. Thanks a lot for uploading such a valuable content.

[jameslamela]

Thank you so much. Much more clear, concise, and understandable. You truly have an educator's soul. Keep up the great work!

[baburamshapure]

Hi Venkat, greetings of the day! These tutorials are invaluable. I literally learned SQL Server by going through them. Really admire your work and the way your teach, so exhaustive. Thank you man. God bless you!

[sondang]

YOU ARE THE GOD, I LOVE YOU AND EVERY TUTORIALS YOU'VE MADE, YOU SAVE MY LIFE. TANKS A MILLIONS

[krismaly]

Revisiting to refresh BASICS.

I enjoyed watching this video and recommend others.

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch

[Ayubajbnabi]

Thanks Mr. Venkat for your wonderful simple and great way of teaching. I love all your tutorials and learnt allot. Have a great day.

[Csharp-video-tutorialsBlogspot]

Hi Srinu, sure will record and upload videos on the concepts you mentioned soon.

[nayanamtanuj]

One more thing to note here is, you can set a default even though that value does not exist in the tblGender table. For instance, just add the default value as 5 and it will be executed properly. But when you insert the entry in tblPerson without passing any value for gender it will start to throw an error because in tblGender 5 does not exist. In order to fix this issue we would need to add the value 5 in the tblGender table.

[marinosanagnostou]

Very good of SQL Server tutorial-series.
Very well done. God job.

[wasimbader]

thank you sir, another nice video and they are all in sequence. I need to learn and master all of it. So I will be seeing all 135 vids.
Regards

[FlareSoul]

Venkat... you are absolutely amazing!! You are the best technical instructor that can break the process of learning down to where we can understand efficiently and effectively. We love you man!!

[nandusawkar]

Very much clear explanation and covered most of the useful topics...

[TigerPony]

Thank you for these awesome videos! It's so easy to understand. 👍👍👍👍👍👍👍👍👍👍👍👍👍

[masjediaqtash]

i was about to join a center for learning SQL server but since i got here i desided to be here only .
its too muxh clear and understandable .
tanx for uploading such usefull toturials .

[MrTechGeek]

you are the best teacher.thanks for your efforts.i Am learning so much thanks..

[suryagowri]

THE explanation of kud venkat sir is very helpfull for sir i am listen this videos and practicing it is a great oppurtunity for me thank you kud venkat sir

[harshilsoni]

hello sir, i am very happy with your extraordinary teaching skills and your explanation is very simple. Thanks, sir for taking out time and making some amazing videos.

[richardarmstrong-finnerty]

Thank you for creating this excellent series of videos. Concise, well-presented, and useful.

[fionamehta]

Really grateful to you - excellent delivery all round - uniform approach - thank you so much !

[naveenpisher]

Its 2021, I am still learning from u. Thank you