Hi i am having 2 tables
table1(RID int PK,RTypeID int FK,Name VarChar,Active bit)
table2(RtypeID int PK,Name,Note,Active)
while changing the name in table 2 i want the changes to be made in table 1 how can i do ?
You may use computed columns or a trigger.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
My Blog |
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?