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

ʹÓÃSQL SERVER´æ´¢¹ý³ÌʵÏÖÒøÐÐתÕËÒµÎñ

ÔÚÒøÐнðÈÚϵͳÖУ¬ÎÒÃdz£³£¶¼ÒªÊµÏÖÒøÐÐתÕËÕâÑùµÄÒµÎñ²Ù×÷£¬¶øÕâÖÖ½ðÈÚϵͳ²¢·¢ÐÔÏ൱¸ß£¬ÐèÒª¿¼ÂǵÄÈçºÎÌá¸ßÐÔÄܺͱ£Ö¤°²È«ÐÔµÈÏà¹ØµÄÎÊÌ⡣ʹÓô洢¹ý³ÌÀ´ÊµÏÖÒøÐÐתÕËÊÇÒ»¸öºÜºÃµÄÑ¡Ôñ¡£
SQL SERVERÊý¾Ý¿âÖеĴ洢¹ý³ÌÏà¶ÔÓÚÓ¦ÓóÌÐòÖÐÀ´²Ù×÷Transact-SQLÓïÑÔµÄÓÅȱµã£º
Óŵ㣺
1.              ´æ´¢¹ý³ÌÒÑÔÚ·þÎñÆ÷×¢²á£¬Ô¤±àÒ룬´æ´¢¹ý³ÌÔ¤ÏȱàÒëºÃ·ÅÔÚÊý¾Ý¿âÄÚ£¬¼õÉÙ±àÒëÓï¾äËù»¨µÄʱ¼ä
2.              ´æ´¢¹ý³Ì¿ÉÒÔÓÃÓÚ¼õÉÙÍøÂçͨÐÅÁ÷Á¿£¬´æ´¢¹ý³Ì´úÂëÖ±½Ó´æ´¢ÓÚÊý¾Ý¿âÖУ¬Ö´ÐеÄʱºòÖ»ÐèÒªÓ¦ÓóÌÐò´«µÝ²ÎÊý¼´¿É£¬¶ø²»ÐèÒªÕû¶ÎµÄT-SQL´úÂë´«µÝµ½Êý¾Ý¿âÖС£
3.              ÖØÓÃÐԸߣ¬Ò»¶Î´æ´¢¹ý³Ì£¬¿ÉÒÔÔÚÓ¦ÓóÌÐòÖв»Í¬µÄλÖÃÀ´µ÷Óá£
4.              ¿Éά»¤ÐԸߣ¬°ÑÕû¸öÒµÎñµÄ²Ù×÷·â×°ÔÚÒ»Æð£¬ÓÐÀûÓÚÒÔºó×ö´úÂëµÄÌæ»»²Ù×÷£¬¶øÓ¦ÓóÌÐò»áÔÚÈպ󲻶ϵÄά»¤ÖУ¬»áµ¼ÖÂTrancSQL¹ý³Ì´úÂë»á±äµÃÔ½À´Ô½¸´ÔÓ£¬Í¬Ê±£¬¸üд洢¹ý³Ìͨ³£±È¸üÐÂÓ¦ÓóÌÐò¼òµ¥µÄ¶à£¬¸üÐÂÓ¦¸Ã³ÌÐòÐèÒª±àÒ룬²¿Êð¡£
5.              ʹÓûº´æ¸ÄÉÆÐÔÄÜ£¬±àÒëºÃµÄ´æ´¢¹ý³ÌÖ±½Ó½øÈëSQL SERVERµÄ»º´æÖУ¬Ê¹µÃÏ´ÎÖ´ÐеÄʱºò£¬ÄÜÂíÉϵ÷Ó᣶øÔÚSQL SERVER 2005ÖУ¬Ö´Ðмƻ®ÒÑÕë¶ÔËùÓÐ T-SQL Åú´¦Àí½øÐÐÁË»º´æ£¬Ð§Âʺʹ洢¹ý³Ì²î²»¶àÁË¡£
6.              Ç¿ÖÆʹÓÃÊý¾Ý¿âÖеݲȫÈÏÖ¤»úÖÆ£¬Ê¹µÃÓ¦ÓóÌÐòµÄ°²È«ÐÔÌá¸ß£º
a)         ¶Ô´æ´¢¹ý³ÌÏòÌض¨Óû§ÊÚȨ£¬Ò²¿ÉÒÔÌṩ¶ÔÌض¨Êý¾ÝµÄ·ÃÎÊ¡£
b)        ÔöÇ¿´úÂ밲ȫ£¬Í¨¹ý´«µÝ²ÎÊýµÄ·½Ê½£¬ÄÜÓÐЧ·ÀÖ¹ SQL×¢Èë¡£
ȱµã£º
1.         ¿ÉÒÆÖ²ÐÔ²î
a)         ÓÉÓÚ´æ´¢¹ý³Ì½«Ó¦ÓóÌÐò°ó¶¨µ½ SQL Server£¬Òò´ËʹÓô洢¹ý³Ì·â×°ÒµÎñÂß¼­½«ÏÞÖÆÓ¦ÓóÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
b)        Èç¹ûÓ¦ÓóÌÐòµÄ¿É


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

ÓÃSQL Server 2005 CTE¼ò»¯²éѯ

SQL Server 2005Òý½øÁËÒ»¸öºÜÓмÛÖµµÄеÄTransact-SQLÓïÑÔ×é¼þ£ºÒ»¸öͨÓñí±í´ïʽ£¨Common Table Expression£¬CTE£©£¬ËüÊÇÅÉÉú±íºÍÊÓͼµÄÒ»¸ö±ã½ÝµÄÌæ´ú¡£Í¨¹ýʹÓÃCTE£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ò»¸öÃüÃû½á¹û¼¯À´ÔÚSELECT¡¢INSERT¡¢UPDATEºÍDELETEÓï¾äÖÐÒýÓ㬶øÎÞÐë±£´æ½á¹û¼¯½á¹¹µÄÈκÎÔªÊý¾Ý¡£ÔÚ±¾ÎÄÖУ¬ÎÒ½«²ûÊöÈçºÎÔÚSQL Server 2 ......

SQL ServerʹÓÃBulk Insert°ÑÒ»¸öÎı¾µ¼Èëµ½Êý¾Ý¿â

 
This is very common request recently – How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the solution in quick steps.
CSV stands for Comma Separated Values, sometimes also called Co ......

³£¼ûOracle HINTµÄÓ÷¨ SQLÓÅ»¯

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO=’SCOTT’;
2. /*+FIRST_ROWS*/
±í ......

½«MySQLÖÐsqlÔËÐнá¹û±£´æµ½Îļþ

 ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚmysql>Ìáʾ·ûÖÐʹÓÃtee
mysql> tee output.txt
Logging to file 'output.txt'
mysql> notee
Outfile disabled.
»òÕß
mysql> \T output.txt
Logging to file 'output.txt'
mysql> \t
Outfile disabled.
Õâ¸öÀàËÆÓÚsqlplusµÄspool¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ