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

SQLÄÑÌâ

ÔõôÈÃÎÒ°®Ëý£¬ËýÒ²°®×ÅÎÒ£¿
SF

bd

ÓÃÐŵͨ£¬Õæ³ÏÏà´ý

½ÚÈÕ¿ìÀÖ£¬½Ó·Ö×ßÈË

¡£¡£¡£

JF°É


~jF

ÒýÓÃ
JF°É


½ã½ã£¬Ä㶼ûɶ¸øÎÒ˵µÄ£¿

С°®ÄãÓзÖÂð£¿
û·Ö¾ÍľÓа취ÁË¡£

¿´Â¥ÉϵÄÇ©Ãû...

...

ÒýÓÃ
С°®ÄãÓзÖÂð£¿
û·Ö¾ÍľÓа취ÁË¡£

ÎÒÓзֵÄʱºòÒ²ÕÒ²»À´£¬¾Í°Ñ·ÖÊäÍêÁË
ÏÖÔÚû·ÖÁË»¹Êǹâ¹÷

ŬÁ¦È¥ÕùÈ¡Ëý

¿´²»¶®£¬Ã²ËÆÄãÒ²²»°®Ëý£¬ËýÒ²²»°®Ä㣬Èç´Ë²»ÊǺܺÃô£¿²»¶®²»¶®....

½¨ºÃÔ¼Êø£¬ÕâÑù¾ÍûÓÐÎÊÌâ¡£

¿ÉÒÔ½áÌû.

..

w

¡£¡£¡£¡£

ÒýÓÃ
ÔõôÈÃÎÒ°®Ëý£¬ËýÒ²°®×ÅÎÒ£¿

ÈÕºóÔÙ˵.

..

.

o

¼òµ¥£º
  where £¨Ëý °® ÎÒ£©or £¨ÎÒ °® Ëý£©

.

sf

JF

¸²¸Ç

jf

±­¾ß

絕對µÄ¼¼術Ìû~~~


Quote=ÒýÓà 31 Â¥ happy_stone µÄ»Ø¸´:]
絕對µÄ¼¼術Ìû~~~

[/Quote]

[


up

jf

ÓÃÐÄ£¬ÄÍÐÄ£¬ºñ»ý±¡·¢¡£


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

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 º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ