sql server2000ÖРȨÏÞÎÊÌâ
ÔÚsql server2000ÖÐ Ôõô°ÑÒ»ÕűíÉèÖóÉËùÓÐÓû§¶¼ÎÞ·¨Ð޸썰üÀ¨¹ÜÀíÔ±£© ÄÜÕâÑùÂð£¿
ºÃÏñ²»¿ÉÄÜ£¬sa¿Ï¶¨ÊÇÄܹ»¸ÄµÄ¡£ sa²»ÄÜÖ¸¶¨£¬ÆäËûµÄ¿ÉÒÔ ÏÖÔÚÎÒÓиöÎÊÌâ¾ÍÊÇ ¿Í»§¾ÍÊÇÓÃsaµÇ½ µ«ÊÇÎÒÏë°ÑÒ»¸ö±íµÄÊý¾Ý¹Ì¶¨ ²»ÈÃËû×öÈκÎÐÞ¸Ä ²»ÖªµÀÔõô¸Ä ÄǸøËûÁíÍâÒ»¸öÓû§²»¾ÍÍêÁË..ÒªÊÇÁ¬sa¶¼²»¿ÉÒÔÐ޸ϹµÃÁË... sql server¾ÍÊÇÕ⣬¹ÜÀíԱȨÏ޺ܸߵ쬲»¿Éº³¶¯°¡ Ó¦¸Ã²»¿ÉÄÜµÄ sa¿ÉÒԸĵÄÒýÓà ÓÃtrigger£¬ËùÓпͻ§ÊäÈëµÄÐÂÖµ¶¼ÓÃÔÀ´µÄÖµ´úÌæ£¿²»ÖªµÀÐв»ÐС£¡£¡£ ÎÒÊÔÊÔ¿´¿© лл ÒýÓà ÄǸøËûÁíÍâÒ»¸öÓû§²»¾ÍÍêÁË..ÒªÊÇÁ¬sa¶¼²»¿ÉÒÔÐ޸ϹµÃÁË... ¾ÍÊDz»ÏëÕâôÂé·³
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ: id workbillno .................. 1 1 2 6 3 a1 4 c2 5 2 6 aa 7 ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡ Óû§ÃûÊÇΨһµÄ ±íA ×Ö¶Î Óû§Ãû£ºName ,ÓÊÏ䣺Ema ......
³¡¾°ÈçÏ£º ¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......