update在sql server与oracle的不同使用

常规update语句(通用):

update  t_user

              set user_name='abc'

               where user_id='a123'

 

oracle:

update t_user tb

             set tb.user_name='abc'

             where user_id='a123'

 

 

sqlserver:

update tb

              set tb.user_name='abc'

              from t_user tb

              where user_id='a123'

--记录下来以备所需