Ritesh Kumar

Ritesh Kumar

  • 1.3k
  • 351
  • 1.5k

trigger in sql update table

Nov 22 2016 8:38 PM
hi sir i have 2 table 
 price ( id  int primary key,
price decimal,
product_name nvarchar(30)) 
 
 
second table is
 
cart (
 
id int primary key,
price_id int foreign key  price(id),
price decimal)  
 
now i want when i change  price values in price table automatic  change in cart table price column  

Answers (2)