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

¡¾³õѧÕßÇó½Ì¡¿SQLServerµÄʱ¼äÓë³ÌÐòÖв»Ò»ÖÂ

loatÀàÐ͵Äֵת»¯ÎªÊ±¼äÊÇ—>
C# code:

DateTime dt = DateTime.fromOADate(40277.4927000525);
MessageBox.Show(dt.ToString());


MessageBoxÏÔʾµÄʱ¼äÊÇ—>2010-4-9 11:49:29

µ«ÊÇͬÑùµÄÊý×Ö£¨¼È40277.4927000525£©£¬Èç¹û´ÓÊý¾Ý¿âÖÐÈ¡³öÀ´ÏÔʾµÄdatagridviewÖУ¬¾Í»á±ÈÉÏÃæµÄʱ¼ä¶àÁ½Ìì¡£
C# code:

SqlDataAdapter da = new SqlDataAdapter("select [ID],cast([Time] as datetime) from DatapointValue2", con);
//×¢:40277.4927000525¾ÍÊÇTimeÁÐijһÐÐÖеÄÖµ



¾­¶Ô±È£¬Í¬ÑùÊÇ40277.4927000525£¬gridviewÖÐÏÔʾµÄÊÇ—>2010-4-11 11:49:29£¬Ò²¾ÍÊDZÈÕæÊµµÄʱ¼ä¶àÁ½Ìì¡£

ÎÒÏÖÔÚÏë×öµÄÊÂÊÇÏëÈÃdataGridviewµÄʱ¼äÏÔʾÕý³££¬¿É·ñÔÚsqlÓï¾äÀïÃæÖ±½Ó¼ôµôÁ½Ì죬»òÕßÓñðµÄ·½·¨¡£Ï£Íû¸ßÊÖÖ¸µã£¡£¡£¡
Íò·Ö¸Ð¼¤£¡£¡£¡£¡£¡£¡


http://msdn.microsoft.com/zh-cn/library/ms186819.aspx

¸Ðл¿Õ¾ü£¬»ØÁË£¡£¡£¡£¡

»ØÁË£¡£¡£¡£¡—>»áÁË£¡£¡£¡£¡


Ïà¹ØÎÊ´ð£º

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

sqlserverÌí¼ÓÊý¾ÝµÄÎÊÌâ - Java / Java EE


ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:

private void new ......

SQLserverÉú³Éinsert into´øÊý¾Ý½Å±¾.

ÓÐʲô¹¤¾ß¿ÉÒÔ°ÑsqlserverµÄÊý¾ÝÉú³Éinsert intoµÄ½Å±¾?ÏñmysqlÄÇÑùµ¼³ö.sqlÎļþ.
mssqlÖ»¿ÉÒÔÉú³É±í½á¹¹µÄsqlÎļþ.²»´øÊý¾ÝµÄ.
Èç¹û±íÉٵϰ
×Ô¼ºÆ´°É

Â¥Ö÷˵µÄÊÇÒª°ÑÊý¾Ý¿âÄÚµÄÒѲåÈëµÄÊý¾ÝתΪSQL½Å±¾?
......

ÇóÀàËÆsqlserverÖÐisnull()º¯ÊýÔÚaccessÖÐÈçºÎʵÏÖ

isnull(a,b)
¼´Èç¹ý×Ö¶ÎaΪnullÔò·µ»Øb
eg:
select isNUll(a,b) from table_1;

Ö±½Ó IFNULL¾ÍÐÐÁË¡£
SQL code:
mysql> select ifnull(null,2);
+----------------+
| ifnull(null,2) |
+------------ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ