Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#¶à̬¸úSQLÊÂÎñÊDz¶àÂð

Ò»¸ö²Ù×÷ͬʱÔËÐÐÁ½¸ö»ò¶à¸ö²Ù×÷
ÓÐÒâ˼,°ïÄã¶¥ÁË.

û¿É±ÈÐÔ¡£


ÓÐÒâ˼£¿

ÒýÓÃ
Á½¸öÍêÈ«²»Ïà¸ÉµÄ¶«Î÷

û¿É±ÈÐÔ¡£Íêȫû¿É±ÈÐÔ¡£

SQLÊÂÎñ²»ÊÇͬ²½ÔËÐÐÂð¡£ ¶à̬Ҳ²»ÊDzúÉú¶à¸öÐÅÏ¢Âð

ÎÒµÄÀí½âѽ£¬¶à̬¾ÍÊǺ¯ÊýÃû²»¹»ÓÃÁË£¬»òÕß˵һ¸öº¯ÊýÃûÒª±í´ï¶à¸öÒâʶ£¬Ôõô°ìÄØ£¬ÖØÔذɶà̬°É¡£

ÍêÈ«Á½ÂëÊ¡£
ÍøÉÏËÑһ϶à̬£¬¿´¿´ËüµÄ¶¨Òå¡£
¶à̬ÊÇÃæÏò¶ÔÏó³ÌÐòÉè¼ÆÖеÄÖØÒª¸ÅÄî¡£¸úËùνͬ²½ÔËÐлò²úÉú¶à¸öÐÅÏ¢ÍêÈ«²»Ïà¸É¡£

ÊÂÎñÊÇΪÁ˱£»¤Êý¾ÝÍêÕûÐÔ¡£¶à̬ÊÇΪÁËÈÃÅÉÉúÀà´Ó»ùÀà¼Ì³Ðʱ£¬»ñµÃ»ùÀàµÄËùÓз½·¨¡¢×ֶΡ¢ÊôÐÔºÍʼþ¡£
ËùÒÔ˵Á½Õ߸ù±¾¾Í²»Ïàͬ

¼ÙÉèÓÐ2¸öÀ࣬CatÀàºÍPersonÀ࣬ÏÖÔÚÕâÁ½¸öÀà¶¼ÓÐÒ»¸ö¹²Í¬µÄEat()¾²Ì¬º¯Êý¡£
µ±ÄãÖ´ÐÐCat.Eat()ºÍPerson.Eat()»á³öÏÖ²»Í¬µÄ½á¹û£¬Õâ¾ÍÊǶà̬ÁË£¡

Ŷ Ô­À´ÊÇÕâÑù°¡ ºÇºÇ

·çÂíÅ£²»Ï༰

Á½ÂëÊÂ



ÒýÓÃ
¼ÙÉèÓÐ2¸öÀ࣬CatÀàºÍPersonÀ࣬ÏÖÔÚÕâÁ½¸öÀà¶¼ÓÐÒ»¸ö¹²Í¬µÄEat()¾²Ì¬º¯Êý¡£
µ±ÄãÖ´ÐÐCat.Eat()ºÍPerson.Eat()»á³öÏÖ²»Í¬µÄ½á¹û£¬Õâ¾ÍÊǶà̬ÁË£¡

µÚÒ»´ÎÌý˵¶à̬ÊÇÕâÑù½âÊ͵Ä,ÊܽÌ..
¶à̬ÊÇÏà¶ÔÓÚͬһ¸ö¶ÔÏó¶øÑÔµÄ,²»Í¬¶ÔÏóÎÞ´Ó̸¶à̬.

ÄѵÀÒ»¸ö½Ó¿ÚÖеÄEat()º¯Êý·Ö±ðÓÉCatÀàºÍPersonÀà¼Ì³ÐºóÔÙ¾ßÌåʵÏÖ£¬Õâ¸ö²»½Ð¶à̬Âð£¿ÎÒÏëÌýÌýÄã¶Ô¶à̬µÄÀí½â£¡15Â¥µÄ£¡

»ù±¾ÉÏ£¬ÎÒÃÇ¿ÉÒÔÕâÑùÀ´Àí½â¶à̬µÄ»úÖÆ£º

¶à̬¸ú¼Ì³ÐÊDz»¿É·Ö¸îµÄ£¬¾ÍÏñһöӲ±ÒµÄÁ½Ãæ¡£

¼ÙÉèÄ㶨ÒåÒ»¸ö·½·¨ m µÄ²ÎÊý£¨±äÁ¿£©x µÄÀàÐÍΪ T£¬µ±ÔËÐÐʱʵ¼Ê´


Ïà¹ØÎÊ´ð£º

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--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 ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ