使用SQL语句写语句查询

Question

1.写函数GetSalaryByNumber，接收员工编号employee_number，返回此员工的工资标准employee_salary。
需要建表Employee，列为：employee_number:varchar(10),employee_salary:money。

Answer 1

 Create function AvgResult(@en varchar(10))
Returns money
As
Begin
   Declare @es money
   Select @es=select top 1 employee_salary from Employee where employee_number = @en
Return @es
End