Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£©


Ïà¹ØÎÊ´ð£º

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

ÈçºÎÔÚMySQL ServerÖж¨Ê±²åÈëÊý¾Ý - Java / Web ¿ª·¢

ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£

quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£

È ......

myeclipse+mysqlµÄÅäÖÃÎÊÌâ - Java / Eclipse

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ