C#¶à̬¸úSQLÊÂÎñÊDz¶àÂð
Ò»¸ö²Ù×÷ͬʱÔËÐÐÁ½¸ö»ò¶à¸ö²Ù×÷
ÓÐÒâ˼,°ïÄã¶¥ÁË.
û¿É±ÈÐÔ¡£
ÓÐÒâ˼£¿
û¿É±ÈÐÔ¡£Íêȫû¿É±ÈÐÔ¡£
SQLÊÂÎñ²»ÊÇͬ²½ÔËÐÐÂð¡£ ¶à̬Ҳ²»ÊDzúÉú¶à¸öÐÅÏ¢Âð
ÎÒµÄÀí½âѽ£¬¶à̬¾ÍÊǺ¯ÊýÃû²»¹»ÓÃÁË£¬»òÕß˵һ¸öº¯ÊýÃûÒª±í´ï¶à¸öÒâʶ£¬Ôõô°ìÄØ£¬ÖØÔذɶà̬°É¡£
ÍêÈ«Á½ÂëÊ¡£
ÍøÉÏËÑһ϶à̬£¬¿´¿´ËüµÄ¶¨Òå¡£
¶à̬ÊÇÃæÏò¶ÔÏó³ÌÐòÉè¼ÆÖеÄÖØÒª¸ÅÄî¡£¸úËùνͬ²½ÔËÐлò²úÉú¶à¸öÐÅÏ¢ÍêÈ«²»Ïà¸É¡£
ÊÂÎñÊÇΪÁ˱£»¤Êý¾ÝÍêÕûÐÔ¡£¶à̬ÊÇΪÁËÈÃÅÉÉúÀà´Ó»ùÀà¼Ì³Ðʱ£¬»ñµÃ»ùÀàµÄËùÓз½·¨¡¢×ֶΡ¢ÊôÐÔºÍʼþ¡£
ËùÒÔ˵Á½Õ߸ù±¾¾Í²»Ïàͬ
¼ÙÉèÓÐ2¸öÀ࣬CatÀàºÍPersonÀ࣬ÏÖÔÚÕâÁ½¸öÀà¶¼ÓÐÒ»¸ö¹²Í¬µÄEat()¾²Ì¬º¯Êý¡£
µ±ÄãÖ´ÐÐCat.Eat()ºÍPerson.Eat()»á³öÏÖ²»Í¬µÄ½á¹û£¬Õâ¾ÍÊǶà̬ÁË£¡
Ŷ ÔÀ´ÊÇÕâÑù°¡ ºÇºÇ
·çÂíÅ£²»Ï༰
Á½ÂëÊÂ
µÚÒ»´ÎÌý˵¶à̬ÊÇÕâÑù½âÊ͵Ä,ÊܽÌ..
¶à̬ÊÇÏà¶ÔÓÚͬһ¸ö¶ÔÏó¶øÑÔµÄ,²»Í¬¶ÔÏóÎÞ´Ó̸¶à̬.
ÄѵÀÒ»¸ö½Ó¿ÚÖеÄEat()º¯Êý·Ö±ðÓÉCatÀàºÍPersonÀà¼Ì³ÐºóÔÙ¾ßÌåʵÏÖ£¬Õâ¸ö²»½Ð¶à̬Âð£¿ÎÒÏëÌýÌýÄã¶Ô¶à̬µÄÀí½â£¡15Â¥µÄ£¡
»ù±¾ÉÏ£¬ÎÒÃÇ¿ÉÒÔÕâÑùÀ´Àí½â¶à̬µÄ»úÖÆ£º
¶à̬¸ú¼Ì³ÐÊDz»¿É·Ö¸îµÄ£¬¾ÍÏñһöӲ±ÒµÄÁ½Ãæ¡£
¼ÙÉèÄ㶨ÒåÒ»¸ö·½·¨ m µÄ²ÎÊý£¨±äÁ¿£©x µÄÀàÐÍΪ T£¬µ±ÔËÐÐʱʵ¼Ê´
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......