×ÜÕ¾·ÖÕ¾MSSQL¿â½á¹¹
Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾¿ÉÒÔ×Ô¶¯»òÊÖ¶¯(¾Ý¾ÝÉèÖõÄÌõ¼þ)ץȡ×ÓÕ¾ÀïÏà¹Ø±íÀïµÄÌí¼ÓµÄÊý¾Ý(×îÐÂÌí¼ÓµÄºÍ×ÜÕ¾ÀïûÓкÍ×ÓÕ¾ÏàͬµÄÐÅÏ¢);
¶þ.ÈçºÎÈÃijһ×ÓÕ¾×Ô¶¯»òÊÖ¶¯(¾Ý¾ÝÉèÖõÄÌõ¼þ)ץȡ×ÜÕ¾µÄÏà¹Ø±íÖеÄÊý¾Ý(ûÓкÍ×ÓÕ¾ÏàͬµÄÐÅÏ¢);
ÍûÓÐÄÜÌṩÓÐЧ¿ÉÐеÄÕûÌå¿â¼Ü¹¹.»òµ¥¶ÀÄܽâ¾ö´ËÀàÎÊÌâµÄ½â¾ö·½°¸;×îºÃÄÜÏêϸЩ.
×¢:ÈçºÎ×ÓÕ¾²»Ö»Èý¸ö¶øÊÇN¸öÄØ?
°ï¶¥À²
B/Sϵͳ²»¾ÍÊǸÉÕâ¸öÊÂÇéµÄô?
ʹÓÃÁ¬½Ó×Ö·û´®Ö±½Ó¶ÁÈ¡·þÎñÆ÷ÉÏÃæµÄÊý¾Ý¾ÍÐÐÁË
һЩÊý¾Ý´¦Àí¿ÉÒÔÔÚ³ÌÐòÖÐÖ´ÐÐ
д¸öС³ÌÐòÁË
¿Ï¶¨ÒªÊÖ¶¯µÄ£¬ÏÈÔ¤¶¨ÒåÈô¸É¸ö×ÓÕ¾»òÕß×ÜÕ¾µÄÁ¬½Ó×Ö·û´®¡£È»ºóÑ¡ÔñÁ¬½Ó×Ö·û´®£¬×ö¶ÔÓ¦Êý¾Ý¿â²Ù×÷¡£
¶÷£¬Õý½â
ËùÓеıí,¼ÓÁ½¸ö×Ö¶Î,Ò»¸ö¼Ç
Ïà¹ØÎÊ´ð£º
˵À´º¦Ðß¹þ£¬ºÇºÇ¡¡
×Ôѧ±à³ÌÒѾÁ½Äê¶àÁË£¬»¹²»»á²é¿´Êý¾Ý¿âÁ¬½Ó³Ø°¡£¬Çë´óÏÀÃÇ˵һÏÂÔõÑù²é¿´Ñ½£¿
±È·½Ëµ£¬ÎÒÓÃIEºÍFFºÍOperaͬʱÒÔÈý¸öÓû§Éí·Ý´ò¿ª±¾µØÍøÕ¾£¨ÍøÕ¾ÔÚIISÉÏ£¬µØÖ·Èçhttp://127.0.0.1/M ......
mssql ÅжÏÊÇ·ñÊÇÈÕÆÚ?
SQL code:
declare @var int
set @var= isdate('g')
if @var =0
print '²»ÊÇÓÐЧÈÕÆÚ'
else
print 'ÊÇÓÐЧÈÕÆÚ'
SQL code:
select * from tb where isdate(×Ö¶Î)=1 ......
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷ÉÏ°²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡ ......
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
± ......
MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»
ÀýÈç±í S_ORDER , ×ֶΠNAME
AAA¾×asdfasd
  ......