如何增加 SQL 查询/存储过程的百分比? [英] How do I increase percentage in SQL query / stored procedure?

问题描述

如何提高 SQL 查询/存储过程的百分比?[关闭] 已回答！

How do I increase percentage in SQL query / stored procedure?[closed] been answered!

推荐答案

试试这个:

如果您只想选择:

SELECT ename, esalary * 1.1 
  INTO name, salary 
    FROM employee 
 WHERE eno='113'

如果你想更新

UPDATE employee
   SET salary =  salary * 1.1 
--If the base salary is store in esalary then use 
--SET salary = esalary * 1.1
 WHERE eno='113'

这篇关于如何增加 SQL 查询/存储过程的百分比?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！