Cascade| Set Null | Set Default with DELETE & UPDATE

This video helps you to understand what is delete & update cascade in sql server and how to use delete cascade , set null and set default in foreign key.
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@suyash7450]

Now my concept of using foreign key has been cleared completely.... thanks for explaining in detail.

[@lotusamaze1142]

Thanks

[@jamessoy9616]

Thank you for this video.

[@lotusamaze1142]

Glad it was helpful!

[@satyaprakashjha19]

while updating the data in parent table i got an error "Cannot update identity column 'Hid'."
should i drop the identity keyword? or there is any alternative!

[@lotusamaze1142]

Disallow insert into identity field
SET IDENTITY_INSERT tablename OFF

[@thulasiraju7713]

Sir why you taken foreign key(cust_id)

[@lotusamaze1142]

for creating relationship in two or more tables, atleast one table must have primary key in my case it is cust_id. Other tables must have the at least one column with same data type(name could be different) i.e cust_Id or customer_id or c_id as foreign key

[@sampath730]

Good

[@lotusamaze1142]

Thanks

[@earthscience4812]

GOOD

[@lotusamaze1142]

Thanks

[@VIPINKUMAR-kb1ru]

🙏🙏🙏🙏🙏🙏🙏

[@lotusamaze1142]

Thanks