¡¾»ã×Ü¡¿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
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ£º
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Óï¾äÔËÓõ½²»Í¬Êý¾Ý¿âÖлáÓÐÂÔ΢µÄ²î±ð£¬¶Ô×Ö·û±äÁ¿µÄÒªÇó£¬Ïà¹Øº¯ÊýµÄ±ä»¯£¬ÒÔ¼°Óï·¨¹æÔòµÄ²»Í¬µÈµÈ£¬ÀýÈ磺oracleÊý¾Ý¿âÖжÔ×Ö¶ÎÃüÃû±ðÃûʱ²»ÐèÒªas ×Ö·û£¬Ã»ÓÐmonth()£¬year£¨£©µÈʱ¼äº¯ÊýµÈµÈ£¬accessÊý¾Ý¿âÖÐÔÚʹÓÃinner joinÖ´ÐÐÄÚ²¿ÁªºÏʱÌõ¼þÐèÓ㨣©£¬µ±È»»¹Óкܶ ......
sysforeignkeys
°üº¬¹ØÓÚ±í¶¨ÒåÖÐµÄ FOREIGN KEY Ô¼ÊøµÄÐÅÏ¢¡£¸Ã±í´æ´¢ÔÚÿ¸öÊý¾Ý¿âÖС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
constid int FOREIGN KEY Ô¼ÊøµÄ ID¡£
fkeyid int ¾ßÓÐ FOREIGN KEY Ô¼ÊøµÄ±í¶ÔÏó ID¡£
rkeyid int ÔÚ FOREIGN KEY Ô¼ÊøÖÐÒýÓõıí¶ÔÏó ID¡£
fkey smallint ......
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 ......
Ôړн¨”²Ëµ¥ÖУ¬ÓÐ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Óï¾ä£¬²é¿´±íÖеÄÊý¾Ý£¬ ......