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

¡¾»ã×Ü¡¿SQL CODE ¾­µä·¾«²Ê


¡¾»ã×Ü¡¿SQL CODE --- ¾­µä·¾«²Ê
Êý¾Ý²Ù×÷Àà SQLHelper.cs
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
°ÙÍò¼¶·ÖÒ³´æ´¢
SQL¾­µä¶ÌС´úÂëÊÕ¼¯ 
ѧÉú±í ¿Î³Ì±í ³É¼¨±í ½Ìʦ±í 50¸ö³£ÓÃsqlÓï¾ä
SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»
 
Óαê
¸ù¾Ý²»Í¬µÄÌõ¼þ²éѯ²»Í¬µÄ±í
INNER JOIN Óï·¨
master.dbo.spt_values µÄÃîÓÃ
¹ØÓÚSQLʱ¼äÀàÐ͵ÄÄ£ºý²éѯ
ÅÅÃû sql
 
ͬ²½Á½¸öÊý¾Ý¿â
QLServerºÍOracle³£Óú¯Êý¶Ô±È
¹úÄÚ×îÐÂ×îÈ«ÃæIPÊý¾Ý¿â
 
 
sql ÏȽøÏȳö ¿â´æ 
BOM ´´½¨Óû§¶¨Ò庯Êý,ÿ¸ö×Ó½Úµãde¸¸½ÚµãµÄÐÅÏ¢
 
 
ÓÃPARSENAMEº¯Êý²ð·Ö×Ö·û´®
½«Ò»¸ö×Ö·û´®·Ö³É¶àÁР
×Ö·û´®·Ö¸îº¯Êý--²ð·Ö³É¶àÐÐ
ºÏ²¢¶àÐеÄijһÁÐÖµ 
ÁкÍÏà¼õ L3-L2
ͳ¼Æ½»²æÏàµÈÁ½ÁÐÔª×æµÄ´ÎÊý È¥µôÖظ´
ÐÐÁРת»» ºÏ²¢ ·Ö²ð
 
 
 
SQL ÄêÁä¶Î ·Ö×éͳ¼Æ
ÿ¸ö·ÖÀàÈ¡×îеļ¸ÌõµÄSQLʵÏÖ
С¼Æ ºÏ¼Æ -ͳ¼Æ
ÇóÿÌìµÄÊÕÈëºÍÖ§³ö
Óû§Ïû·Ñ×ܽð¶î 2000ÒÔÏ 2000-4000 4000-6000
ÓÐСʱ¡¢·ÖÖÓ£¬Çóƽ¾ù¹¤×÷ʱ¼ä
µç»°Í¨»°´ÎÊýÒÔ¼°Ê±³¤ 
ʱ¼äÌìÊýÏà²î5ÌìÒÔÉϲ¢ÇҼǼÌõÊý´óÓÚ2µÄÐÅÏ¢
ͳ¼ÆÎÄÕ¸÷ÖÖ·ÖÀà×ÜÊý
½üÆÚ¼Û¸ñ´¦ÓÚ½µ¼ÛÇ÷ÊÆ£¨ÖÁÉÙµ÷ÁË3´Î£©µÄËùÓÐÉÌÆ·
°à¼¶¿¼ÊÔÈËÊý´óÓÚ10¡¢°à¼¶×îµÍ·ÖÔÚ50·ÖÒÔÉÏ¡¢¼ÆËã»úѧԺ¡¢°à¼¶Æ½¾ù·Ö´Ó¸ßµ½µÍÇ°10Ãû 
È¡³öµã»÷Á¿×î¸ßµÄÎÄÕÂ100ƪ£¬Ã¿¸ö×÷Õß²»³¬¹ý5ƪ
 
 
 
ÈçºÎÏòÒ»¸ö×ÔÔö×ֶβåÖµ
²é×Ö¶ÎÖ¸¶¨Êý¾ÝºóÒ»ÐмǼ 
ÕÒ³öÓëijidÏà½üµÄËÄÌõ¼Ç¼
 
 
Í£Ö¹Êý¾Ý¿âµÄÓû§Á¬½Ó
½â¾ö²¢Çå³ýSQL±»×¢Èë<script>¶ñÒⲡ¶¾´úÂëµÄÓï¾ä 
http://www.cnblogs.com/zengxiangzhan/archive/2010/05/12/1733758.html
http://topic.csdn.net/u/20100512/17/1a5fb051-6c38-495e-955d-6a040cf74662.html


Ïà¹ØÎĵµ£º

ORACLEÖÐÓÃrownum·ÖÒ³²¢ÅÅÐòµÄSQLÓï¾ä

µÚÒ»ÖÖ£º 
select b.* from
 ( select a.*, rownum row_num from
   (select t.* from A05_ORGANIZATION t order by org_name_en asc) a
  ) b
 where b.row_num  between 1 and 5  order by b.row_num asc
µÚ¶þÖÖ£¨¸ü¸ßЧ£©£º
select b.* from
 ( select a.*, rown ......

Êý¾Ý²É¼¯Öг£ÓõÄSQLÓï¾ä¼°¼¼ÇÉ

Êý¾Ý²É¼¯Öг£ÓõÄSQLÓï¾ä
   ÏàͬµÄSQLÓï¾äÔËÓõ½²»Í¬Êý¾Ý¿âÖлáÓÐÂÔ΢µÄ²î±ð£¬¶Ô×Ö·û±äÁ¿µÄÒªÇó£¬Ïà¹Øº¯ÊýµÄ±ä»¯£¬ÒÔ¼°Óï·¨¹æÔòµÄ²»Í¬µÈµÈ£¬ÀýÈ磺oracleÊý¾Ý¿âÖжÔ×Ö¶ÎÃüÃû±ðÃûʱ²»ÐèÒªas ×Ö·û£¬Ã»ÓÐmonth()£¬year£¨£©µÈʱ¼äº¯ÊýµÈµÈ£¬accessÊý¾Ý¿âÖÐÔÚʹÓÃinner joinÖ´ÐÐÄÚ²¿ÁªºÏʱÌõ¼þÐèÓ㨣©£¬µ±È»»¹Óкܶ ......

SQL Server ϵͳ±í

sysforeignkeys
°üº¬¹ØÓÚ±í¶¨ÒåÖÐµÄ FOREIGN KEY Ô¼ÊøµÄÐÅÏ¢¡£¸Ã±í´æ´¢ÔÚÿ¸öÊý¾Ý¿âÖС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
constid  int  FOREIGN KEY Ô¼ÊøµÄ ID¡£
fkeyid  int  ¾ßÓÐ FOREIGN KEY Ô¼ÊøµÄ±í¶ÔÏó ID¡£
rkeyid  int  ÔÚ FOREIGN KEY Ô¼ÊøÖÐÒýÓõıí¶ÔÏó ID¡£
fkey  smallint ......

SQL ×Ö·û´®½ØȡʾÀý

SELECT LEFT(RTRIM('20080927p1058'),LEN('20080927p1058')-2)
 
SELECT SUBSTRING('20080927p1058',1,LEN('20080927p1058')-2)
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*whit ......

pl/sql developerµÄʹÓÃ

Ôړн¨”²Ëµ¥ÖУ¬ÓÐProgram window£¬Test window£¬SQL windowºÍCommand windowµÈ¡£
SQL windowºÍCommand windowÓÐʲôÇø±ð£¿£¿
Command windowʵÏÖÁËSQL*PlusµÄËùÓй¦ÄÜ£¬ÔÊÐíÔËÐÐsql*plusÃüÁsqlÃüÁsql½Å±¾¡£
SQL windowÓÃÓÚÖ´ÐÐsqlÓï¾ä£¬ÏÔʾsqlÊä³ö£¬Ö´ÐÐͳ¼ÆÐÅÏ¢¡££¨²âÊÔsqlÓï¾ä£¬²é¿´±íÖеÄÊý¾Ý£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ