更新数据库的SQL语句咋写?解决方法

更新数据库的SQL语句咋写?insertintosr(deal_State)values( End )wheretopic&Label7.Text&????wrong!!!

更新数据库的SQL语句咋写?
insert   into   sr(deal_State)   values( 'End ')   where   topic= ' "   &   Label7.Text   &   " '

????wrong!!!

[解决办法]

update sr set deal_State= 'End ' where topic= ' " & Label7.Text & " '