09 2012 档案
摘要：SQL计算两个日期之间相差的工作天数http://blog.163.com/im_foto/blog/static/49085060200953010553914/ ----计算两个日期之间相差的工作天数CREATE FUNCTION f_WorkDateDiff(@dt_begin datetime,@dt_end datetime)RETURNS intASBEGIN DECLARE @workday int,@i int,@bz bit,@dt datetime IF @dt_begin>@dt_end SELECT @bz=1,@dt=@dt_bsegin,@dt_begin=@
阅读全文
posted @ 2012-09-20 18:00
摘要：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls; public partial class EMP_emp_info : System.Web.
阅读全文
posted @ 2012-09-17 17:23
摘要：1 概述最近维护系统时，客户经常反馈这样一个内容：要在查询列表上加上一个查询条件。这样的要求一点也不过分，并且看起来工作量也不大，不就是加一个WHERE条件嘛，但是当调试到DAL层时，立刻石化——遇到在SELECT子句中编写子查询的SQL，SELECT SO.order_no,(SELECT SUM(SOD.good_num) FROM [StockOrderDetails] AS SOD WHERE SOD.order_id=SO.id) AS order_numFROM [StockOrder] AS SO 这样的写法缺点如下：1>order_num不能在SELECT中继续使用2&g
阅读全文
posted @ 2012-09-08 11:02
摘要：--以工作日計算起始年假的計算時間範圍declare @settoday smalldatetime,@birthday smalldatetime,@year varchar(10),@month varchar(10),@day varchar(10),@enddate datetime,@stardate datetime,@AnnualNumber int,@AnnualTotal int,@Surplus int set @settoday='2013-05-04'--現在日期set @birthday='2004-04-26' ---進公司日期set
阅读全文
posted @ 2012-09-08 11:00
|
||
