CREATE FUNCTION workdayadd( @date datetime, --»ù´¡ÈÕÆÚ @workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý )RETURNS datetime AS BEGIN DECLARE @bz int --Ôö¼ÓÕûÖܵÄÌìÊý SELECT @bz=CASE WHEN @workday<0 THEN -1 ELSE 1 END ,@date=DATEADD(Week,@workday/5,@date) ,@workday=@workday%5 --Ôö¼Ó²»ÊÇÕûÖܵŤ×÷ÌìÊý WHILE @workday<>0 SELECT @date=DATEADD(Day,@bz,@date), @workday=CASE WHEN (@@DATEFIRST+DATEPART(Weekday,@date)-1)%7 BETWEEN 1 AND 5 THEN @workday-@bz ELSE @workday END --±ÜÃâ´¦ÀíºóµÄÈÕÆÚÍ£ÁôÔڷǹ¤×÷ÈÕÉÏ WHILE (@@DATEFIRST+DATEPART(Weekday,@date)-1)%7 in(0,6) SET @date=DATEADD(Day,@bz,@date) RETURN(@date) ENDÔÚÏߵȸßÊÖ »ØÂ¥ÉÏ
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44 Í ......