asp.net
用asp.net 做的 假期处理 要把假期的类型如“事假”的天数加起来 如何实现 --------------------编程问答-------------------- 拿数据的时候求和不得了吗 --------------------编程问答-------------------- select sum(sday) from table where 假期的类型='事假'总之在sql中处理。 --------------------编程问答-------------------- select sum(datediff(day, endtime, starttime)) from table where id = uid --------------------编程问答-------------------- sql="selct sum(holidaynum) as mucount from holidaylist where employeeno='"&EmployeeNo&"' and hdate>='"&hdate&"' and heate<='"&heate&"' "这样写哪里错了吗? --------------------编程问答-------------------- 你这个到底是写在程序当中还是存储过程当中,怎么有那么多“&”这个符号呢,在存储过程中这样写
--------------------编程问答-------------------- 怎么解决 --------------------编程问答-------------------- set rs=Server.CreateObject("ADODB.recordset")
set sql='selct sum(holidaynum) as mucount from holidaylist where employeeno='+@EmployeeNo+' and hdate>='+@hdate+' and heate<='+@heate'
sql="select * from HR_HolidayType order by holidaytypeid "
rs.open sql,conn,1
for i=1 to rs.recordcount
holidaytypeid=rs("holidaytypeid")
holidaytypename=rs("holidaytypename")
补充:.NET技术 , ASP.NET