瑞星卡卡安全论坛

首页 » 技术交流区 » 系统软件 » 【求助】VFP编程
MJpipi - 2006-8-16 0:37:00
请问以下两段程序有什么区别?
creat view view_ca as;
SELECT Employee.职工号, Employee.姓名,;
  YEAR(DATE())-YEAR(Employee.工作日期) AS 年龄;
FROM orders_manage!employee;
ORDER BY 3 DESC

creat view view_ca;
as select employee.职工号,姓名,year(date())-year(出生日期) as 年龄 from orders_manage!employee order by 3 desc
1
查看完整版本: 【求助】VFP编程