Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mssqlº¯Êý·­Òë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¹òÇó½«ÒÔϺ¯Êý·­ÒëΪ mysql µÄÓï·¨


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
ÔÚÏߵȸßÊÖ


»ØÂ¥ÉÏ

ÒÔÉϺ¯Êý¹¦ÄÜÀýÈ磺¡°workdayadd('2009-10-01',3)¡±
·µ»Ø2009-10-01Ö®ºó3¸ö¹¤×÷ÈÕµÄÈÕÆÚ£¬µÚ¶þ¸ö²ÎÊýÒ²¿ÉÒÔÓøºÖµ£¬Í¬ÀíµÃµ½Ö®Ç°3¸ö¹¤×÷ÈÕµÄÈÕÆÚ

ÌÞ³ýÖÜÄ©ÓõÄ

ÒýÓ÷µ»Ø2009-10-01Ö®ºó3¸ö¹¤×÷ÈÕµÄÈÕÆÚ
¾ßÌåÊÇʲôÈÕÆÚ£¿ ÁíÍ⽨Òé¶à¸ø¼¸¸ö²âÊÔÓÃÈÕÆÚ¡£

ÊÇÕâÑùµÄ£º
  ±ÈÈ磺workdayadd('2010-05-06',3£© ·µ»Ø£º2010-05-11
  workdayadd('2010-05-06',-3£© ·µ»Ø£º2010-05-03
  workdayadd('2010-05-06',-8£© ·µ»Ø£º2010-04-26
  workdayadd('2010-05-06',8£©


Ïà¹ØÎÊ´ð£º

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

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
Í ......

mysql½¨±í´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£
Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£

µ±ÄúµÄÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ