ΪÁ˸üºÃµÄ°ïÖú´ó¼Ò ÇëÈý뽫ÄãÃÇ×ܽáµÄsql Óï¾ä´ò¸öѹËõ°ü Ìṩ´ó¼ÒÏÂÔØ°É
ÎÒÃÇ×ªÔØµÄʱºò»á½« ÏÂÃæµÄÄÚÈÝÒ»Æð×ªÔØÉÏÈ¥µÄ£¬Ç°ÌáÄãÃǵÄsqlÓï¾äÉÏÓÐÕâЩ°¡
/*
±êÌ⣺Çå³ýÈÕÖ¾ºÍÊÕËõÈÕÖ¾
×÷Õߣº°®Ð¾õÂ޷ع»ª
ʱ¼ä£º2008-07-14
µØµã£ºÐ½®ÎÚ³ľÆë
×ÊÁÏÀ´Ô´£ºÉîÛÚÍâ¾Ã³¾ÖÄê¼ìÊý¾Ý¿âºÍCSDN»áÔ±adis789×Éѯsql serverÈÕ־Ϊɶ»áÔö³¤ºÜ¿ì£¬
ÓÐÒ»¸ö³ÌÐòÿ5ÃëÖÓдÊý¾ÝÒ»´Î£¬È»ºóÊý¾Ý¿âÈÕÖ¾¾³£Ôö³¤ºÜ¿ì£¬Ôõô±ÜÃâÕâÑùµÄÊÂÇé·¢ÉúÄØ£¿
ÔõôÄÜÈÃsql serverÈÕÖ¾Ôö³¤²»ÒªÕâô¿ì£¬Êý¾ÝÎļþ²Å100MÈÕÖ¾Îļþ¾ÓÈ»1G¶à¡£
*/
ÎÒÔÚÕâÀïÌæ´ó¼ÒллÈýλÁË
´ó¼Ò¶¥Æð°¡
...
學習~~
...
°ï¶¥¡£
學習~~
Õâ¿ÉµÃ·Ñʱ¼äÁË,ÖÁÉÙ½ñÄêÊÇÍê³É²»ÁËÄãµÄÐÄÔ¸ÁË.
¡£¡£¡£
¹þ¹þ ÎÒ¶¼ÊdzϮÎÚ¹êµÄ ÓÐÇëÎÚ¹ê
ÎÒÊÇר³ÌÀ´Ä¤°ÝF椵Ä
ͬÉÏ
ºÇºÇ
ÒªÇóÊDz»Êǹý·ÖÁ˵㰡
ÓÐʱ¼ä¸ø×ܽáϰÉ
ºÇºÇ
ÒªÇóÊDz»Êǹý·ÖÁ˵㰡
ÓÐʱ¼ä¸ø×ܽáϰÉ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
ÎÒÕâÀïÓÐÒ»¸öµÇ½WIFIÍøÂçµÄÒ³Ãæ¡£ÓÉÓÚWIFI¾³£¶ÏÏߣ¬ËùÒÔÒª·´¸´µØÔÚÕâ¸öÍøÒ³Éϵǽ£¬Ã»·¨ÎÞÈËÖµÊØ¡£
ËùÒÔ£¬ÎÒÏë×öÒ»¸öC#³ÌÐò£¬·ÅÒ»¸öwebbrowser¿Ø¼þ£¬×Ô¶¯Ìî±í²¢×Ô¶¯µã»÷Ìá½»°´Å¥¡£
ÎÊÌâÒ»£º
»ù±¾ÕÕÍøÉÏÕҵijÌÐò ......