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