Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

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

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


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡

±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ ......

¼±¼±¼±,SqlServerµÄÎÊÌâ

ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......

ÇóÀàËÆ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ºÅ