Update Table value if corresponding values change in another Table in SQL Server

Question

tblDefClassClassIDClassName1One2Two tblStudentStuIDClassNameSName1OneABC2OneSKY3OneXYZ If I made change in ClassName in the tblDefClass then this change also should be reflected in the tblStudent Letrsquos suppose I change ClassName from ldquoOnerdquo  to ldquoOne19rdquo in the tlDefClass then tblStudent should be look like thistblStudentStuIDClassNameSName1One19ABC2One19SKY3One19XYZ

dharmendr · Accepted Answer

Hi smileYou need to update the tblDefClass aswell It is not possible to change the column value automaticallyOnce you have changed tblDefClass you have to write update query to update the records in tblStudentIt is better instread of ClassName in tblStudent use ClassID as foreignkey in the table So there will no need to change in tblStudent table for every record

Update Table value if corresponding values change in another Table in SQL Server

Company

Explore

Follow us

Contact Us

ClassID	ClassName
1	One
2	Two

StuID	ClassName	SName
1	One	ABC
2	One	SKY
3	One	XYZ

StuID	ClassName	SName
1	One-19	ABC
2	One-19	SKY
3	One-19	XYZ