MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota/blog/item/ef105890249fa684a977a4dc.html
SQL code:
Àý×Ó£º
Êý¾Ý¿âTESTÖдæÔÚ±í
mc qcid jg bz
-------------------- ----------- ----------- ----------
name1 1 4 g
name1 2 4 g
name2 1 4 g
name2 2 4 g
name3 1 4 g
name3 2 4 g
name4 1 4 g
name5 1 4 g
name6 1 4 g
name7 1 4 g
name8 1 4 g
name9 1 4 g
ÏÖÔÚÒª½«×Ö¶ÎqcidÇåΪ0
½¨Á¢JOB:
µã»÷SQL SERVER ´úÀí-¡·×÷Òµ-¡·Ð½¨×÷Òµ-¡·Ãû³ÆÌËæ±ãÌ E-¡·µã»÷²½Öè-¡·Ð½¨-¡·²½ÖèÃû³ÆÌîE-¡·
Êý¾Ý¿âÑ¡ÔñTEST-¡·ÃüÁîÀïÃæдÉÏupdate test set qcid=0-¡·µã»÷¼Æ»®-¡·Ð½¨-¡·¼Æ»®Ãû³ÆE-¡·ÆµÂÊÄÇÑ¡ÔñÄãµÄJOBÖ´ÐеÄʱ¼ä£¨¾ßÌå¿´×Ô¼ºµÄÐèÒª£©-¡·×îºóµã»÷È·¶¨
ÏÂÃæÀ´Ö´ÐÐÏÂJOB£¬ÔÙ¿´¿´±íÀïµÄÊý¾Ý
-----------
mc qcid jg bz
-------
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í:
{ÓÉÓÚ´úÂëÒѾ¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£}
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó
²¢ÇÒÔÚc ......