编写过程存储
现有表m，内有列a,b,c,d,e,f
欲编写存储过程并调用。实现对的公式a^2+b/c+d*e+(f+c^d)的计算。
如何为实现，尽量详细。
------解决方案--------------------
- SQL code
goif OBJECT_ID('test')is not nulldrop table testgocreate table test(a int,b int,c int,d int,e int,f int)goinsert testselect 1,2,4,3,5,6 union allselect 2,3,1,6,5,7--如果是处理表里的数据：select a*a+c/b+d*e+f+c*c*c as value from test/*value8842*/goif OBJECT_ID('pro_tracy')is not nulldrop proc pro_tracygocreate proc pro_tracy @a int,@b int,@c int,@d int,@e int,@f intasselect @a*@a+@c/@b+@d*@e+@f+@c*@c*@c as totalexec pro_tracy 1,2,4,3,5,6/*total88*/
------解决方案--------------------
- SQL code
select square(a) + b/c + d*e + (f + power(c, d))from m;