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
-------
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í:
{ÓÉÓÚ´úÂëÒѾ¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£}
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó
²¢ÇÒÔÚc ......