mssql ¼¶ÁªÉ¾³ý
Á½ÕÅ±í½¨Á¢Á˸üм¶Áª¹ØÏµ£¬µ«Ã»×öɾ³ý¼¶Áª£¬ÏÖÔÚɾ²»µôÊý¾ÝÁË£¬Ôõô°ì£¿×îºÃÊDz»¸Ä±ä±í½á¹¹µÄ~~~
¸÷λ´óϺ°ï°ïæ°¡~~
´¥·¢Æ÷
´´½¨¸öɾ³ý´¥·¢Æ÷
Õâô¿ì¾ÍÓÐÈË´ðÀ²~~¸Ð¶¯¡£¡£¡£Ð»Ð»
µ«ÒòΪÓÐ50¸ö·þÎñÆ÷ÔÚÓã¬ÄÇÿ¸ö·þÎñÆ÷µÄÊý¾Ý¿â¶¼Òª¸Ä¾ÍÂé·³ÁË¡£¡£¡£
SQLÓï¾ä²»ÄÜÖ±½Óɾ³ýÂð£¿
û×ö¼¶ÁªÉ¾³ýÖ»ÄÜÐÞ¸ÄÁË ×ö´¥·¢Æ÷
´¥·¢Æ÷
¶àл¸÷λ°ï棬½áÌùÉ¢·Ö¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î
oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......
ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£
Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²» ......
===================================
ÎÞ·¨Á¬½Óµ½ .¡£
===================================
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......
±¾ÈËÕýÔÚѧmssql£¬¸Õ¿´µ½´æ´¢¹ý³Ì£¬ÓÐЩ²»Ã÷°×£¬Çë´ïÈ˰ѷ±ÔӵĶ«Î÷£¬¼òµ¥»¯£¬ÐÎÏ󻯸øÎÒ½²½²£¬´æ´¢¹ý³ÌÔõôÓã¬Ã²ËÆ´æ´¢¹ý³ÌµÄ´úÂë·Åµ½²éѯ·ÖÎöÆ÷£¬µãÏÂÖ´ÐпÉÒÔ²Ù×÷£¬µ«ÊÇÆ½Ê±¶¼ÕâÑùÓÃô£¬ÄÜ×Ô¶¯µ÷ ......