mssql ¼¶ÁªÉ¾³ý
Á½ÕÅ±í½¨Á¢Á˸üм¶Áª¹ØÏµ£¬µ«Ã»×öɾ³ý¼¶Áª£¬ÏÖÔÚɾ²»µôÊý¾ÝÁË£¬Ôõô°ì£¿×îºÃÊDz»¸Ä±ä±í½á¹¹µÄ~~~
¸÷λ´óϺ°ï°ïæ°¡~~
´¥·¢Æ÷
´´½¨¸öɾ³ý´¥·¢Æ÷
Õâô¿ì¾ÍÓÐÈË´ðÀ²~~¸Ð¶¯¡£¡£¡£Ð»Ð»
µ«ÒòΪÓÐ50¸ö·þÎñÆ÷ÔÚÓã¬ÄÇÿ¸ö·þÎñÆ÷µÄÊý¾Ý¿â¶¼Òª¸Ä¾ÍÂé·³ÁË¡£¡£¡£
SQLÓï¾ä²»ÄÜÖ±½Óɾ³ýÂð£¿
û×ö¼¶ÁªÉ¾³ýÖ»ÄÜÐÞ¸ÄÁË ×ö´¥·¢Æ÷
´¥·¢Æ÷
¶àл¸÷λ°ï棬½áÌùÉ¢·Ö¡£¡£¡£
Ïà¹ØÎÊ´ð£º
===================================
ÎÞ·¨Á¬½Óµ½ .¡£
===================================
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......
ÈçºÎ½«ÄÚÈÝΪ¡°2009-07-31 08:06:04.640¡±µÄʱ¼ä×Ö¶ÎÔÚ±£Áôʱ¼äÀàÐ͵ÄǰÌáÏÂת»¯Îª¡°2009-07-31¡±µÄÈÕÆÚ¸ñʽ£¿
SQL code:
select convert(varchar(10),'2009-07-31 08:06:04.640',120)
/*
----------
2009-07- ......
ÎÒ°ÑACCESSÊý¾Ý¿âת³ÉSqlSERVERºó£¬ºÜ¶à±íÀï¶àÁËupsize_ts×ֶΣ¬Êý¾ÝÀàÐÍΪtimestamp£¬ÇëÎÊÕâ¸ö×ֶθÉʲôÓõģ¬¿ÉÒÔɾ³ýÂð£¿
¿ÉÒÔ刪³ý~~
timestamp
timestamp ÕâÖÖÊý¾ÝÀàÐͱíÏ ......
½²MSSQLÔÚC#ÖеÄÓ¦Óã¬×îºÃ´Ó»ù´¡¿ªÊ¼¡£
ÒªWINFORMµÄ£¬ASP.NET²»Ì«Ï²»¶- =£¡
Ê鲻̫Çå³þ,Õâ¸ö±ðÈËÕûÀíµÄһϵÁеÄC#¿ª·¢WinFormÓ¦ÓÃÎÄÕ¼°Ïà¹Ø´úÂë,Äã¿ÉÒÔÈ¥¿´¿´,ÎÒ¾õµÃͦ²»´íµÄhttp://www.cnblogs.com/peter ......