Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mssql ¼¶ÁªÉ¾³ý

Á½ÕÅ±í½¨Á¢Á˸üм¶Áª¹ØÏµ£¬µ«Ã»×öɾ³ý¼¶Áª£¬ÏÖÔÚɾ²»µôÊý¾ÝÁË£¬Ôõô°ì£¿×îºÃÊDz»¸Ä±ä±í½á¹¹µÄ~~~
¸÷λ´óϺ°ï°ïæ°¡~~
´¥·¢Æ÷

´´½¨¸öɾ³ý´¥·¢Æ÷

Õâô¿ì¾ÍÓÐÈË´ðÀ²~~¸Ð¶¯¡£¡£¡£Ð»Ð»
µ«ÒòΪÓÐ50¸ö·þÎñÆ÷ÔÚÓã¬ÄÇÿ¸ö·þÎñÆ÷µÄÊý¾Ý¿â¶¼Òª¸Ä¾ÍÂé·³ÁË¡£¡£¡£
SQLÓï¾ä²»ÄÜÖ±½Óɾ³ýÂð£¿

û×ö¼¶ÁªÉ¾³ýÖ»ÄÜÐÞ¸ÄÁË ×ö´¥·¢Æ÷

´¥·¢Æ÷

¶àл¸÷λ°ï棬½áÌùÉ¢·Ö¡£¡£¡£


Ïà¹ØÎÊ´ð£º

MSSQLÎÞ·¨Æô¶¯

===================================

ÎÞ·¨Á¬½Óµ½ .¡£

===================================

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......

Çë½ÌÒ»¸öMSSQL¸ñʽ»¯ÈÕÆÚ×Ö¶ÎÎÊÌâ

ÈçºÎ½«ÄÚÈÝΪ¡°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- ......

mssql upsize_ts×Ö¶ÎÎÊÌâ

ÎÒ°ÑACCESSÊý¾Ý¿âת³ÉSqlSERVERºó£¬ºÜ¶à±íÀï¶àÁËupsize_ts×ֶΣ¬Êý¾ÝÀàÐÍΪtimestamp£¬ÇëÎÊÕâ¸ö×ֶθÉʲôÓõģ¬¿ÉÒÔɾ³ýÂð£¿
¿ÉÒÔ刪³ý~~

timestamp 
  timestamp  ÕâÖÖÊý¾ÝÀàÐͱíÏ ......

ÇëÍÆ¼öÒ»±¾C#ÓëMSSQL½áºÏµÄÊé

½²MSSQLÔÚC#ÖеÄÓ¦Óã¬×îºÃ´Ó»ù´¡¿ªÊ¼¡£
ÒªWINFORMµÄ£¬ASP.NET²»Ì«Ï²»¶- =£¡

Ê鲻̫Çå³þ,Õâ¸ö±ðÈËÕûÀíµÄһϵÁеÄC#¿ª·¢WinFormÓ¦ÓÃÎÄÕ¼°Ïà¹Ø´úÂë,Äã¿ÉÒÔÈ¥¿´¿´,ÎÒ¾õµÃͦ²»´íµÄhttp://www.cnblogs.com/peter ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ