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

sqliteµÄsqlÓï¾äÎÊÌâ

sqlite²»»á²»Ö§³Öand °É?
select * from table where rootid=2 and uid=0 order by orderid asc,id asc
ʹÓÃÉÏÃæµÄÓï¾ä²éѯ²»µ½Êý¾Ý,¿ÉÊÇ·ûºÏµÄÌõ¼þÊÇ´æÔÚµÄ.ÎÒÈ¡µôand,¾ÍÓмǼ,²»ÖªµÀÔõô»ØÊÂ
select * from table where rootid=2 order by orderid asc,id asc

ÊÔÒ»ÏÂselect * from table where uid=0;

ÒýÓÃ
ÊÔÒ»ÏÂselect * from table where uid=0;


ÕâÑùÊÇ¿ÉÒÔµÄ,¿ÉÊǺóÃæ¼ÓÉÏÁíÒ»¸öÌõ¼þ,ÎÒÊÔ¹ýÁË,and roorid=1¿ÉÒԲ鵽,¿ÉÊÇand roorid=2¾Í²é²»µ½ÁË,µ«ÎÒ¿´Êý¾Ý¿â,·ûºÏÌõ¼þµÄ,Óа¡

³öÏÖÕâÖÖÇé¿ö?ÎÒ²ÂÓ¦¸ÃÊÇÄãµÄÊý¾Ý¿âÓÐÎÊÌâÁË,ÖØÐÂÏÂÔØÒ»¸ö°²×°°É!

ÎÒ¸Õ²ÅɾÁËÈ«²¿Êý¾Ý,´ÓмÓÁËÁ½Ìõ,ÊÔÁËÏÂselect * from table where uid=0;ÕâÌõ,²»ÐÐ,²é²»µ½,²»ÖªµÀʲôԭÒò,uidÊÇÊý×é×Ö¶Î,ÎÒÒª²éѯµÈÓÚ0µÄ,ÄѵÀ²»ÊÇÕâÑùÂð?

"Êý×é×Ö¶Î"ʲôÒâ˼?

¼ÈÈ»
uid=0
ûÓнá¹û
ÄÇô
rootid=2 and uid=0
¾Í¸ü²»»áÓнá¹ûÁË¡£

ÎÒµÄÒâ˼ÊÇ,uid=0µÄÊý¾ÝÊÇ´æÔÚµÄ,µ«ÊDzéѯ²»µ½.

½¨ÒéÖØ×° ¿Ï¶¨ÊÇÄÄĬÈϵÄÅäÖÃÎÊÌâ³ö´í³åÍ»ÁË


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½Ãæȥѧϰ
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔÇ°,Óùý¸öÒ»¸ ......

SQL 2005ÆóÒµ°æ

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿Ú, error: 26 - ¶¨Î»Ö¸¶¨µÄ·þÎñÆ÷/ʵÀýʱ³ö´í)


== ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ