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

SQL Server ´æ´¢¹ý³Ì

SQL   Server   7.0   ÈëÃÅ(7)  
   
  ʱ¼ä£º2001/02/06   11:57   ×÷Õߣº¶¹¶¹   CHINAASP    
     
   
   
  ¡¡   ʹÓÃÁÙʱ±í   ÁÙʱ±íÊÇÔÚTempDBÖд´½¨µÄ±í¡£ÁÙʱ±íµÄÃû³Æ¶¼ÒÔ“#”¿ªÍ·¡£ÁÙʱ±íµÄ·¶Î§Îª´´½¨ÁÙʱ±íµÄÁ¬½Ó¡£ÒòΪ£¬ÁÙʱ±í²»ÄÜÔÚÁ½¸öÁ¬½ÓÖ®¼ä¹²Ïí£¬Ò»µ©Á¬½Ó¹Ø±Õ£¬ÁÙʱ±í¾Í»á±»¶ªÆú¡£Èç¹ûÁÙʱ±í±»´´½¨ÓÚ´æ´¢¹ý³ÌÖ®ÖУ¬ÔòÁÙʱ±íµÄ·¶Î§ÔÚ´æ´¢¹ý³ÌÖ®ÖУ¬»òÕß±»¸Ã´æ´¢¹ý³Ìµ÷ÓõÄÈκδ洢¹ý³ÌÖ®ÖС£Èç¹ûÐèÒªÔÚÁ¬½ÓÖ®¼ä¹²ÏíÁÙʱ±í£¬ÔòÐèҪʹÓÃÈ«¾ÖµÄÁÙʱ±í¡£È«¾ÖµÄÁÙʱ±íÒÔ“##”·ûºÅ¿ªÍ·£¬Ëü½«Ò»Ö±´æÔÚÓÚÊý¾Ý¿âÖУ¬Ö±µ½SQL   ServerÖØÐÂÆô¶¯¡£Ò»µ©ÕâÀàÁÙʱ±í´´½¨Ö®ºó£¬ËùÓеÄÓû§¶¼¿ÉÒÔ·ÃÎʵ½¡£ÔÚÁÙʱ±íÉϲ»ÄÜÃ÷È·µØÖ¸Ã÷ȨÏÞ¡£   ÁÙʱ±íÌṩÁË´æ´¢Öмä½á¹ûµÄÄÜÁ¦¡£ÓÐʱºò£¬ÁÙʱ±í»¹ÄÜͨ¹ý½«Ò»¸ö¸´ÔӵIJéѯ·Ö½â³ÉÁ½¸ö²éѯ¶ø»ñµÃÐÔÄܵĸÄÉÆ¡£Õâ¿ÉÒÔͨ¹ýÊ×ÏȽ«µÚÒ»¸ö²éѯµÄ½á¹û´æÔÚÁÙʱ±íÖУ¬È»ºóÔÚµÚ¶þ¸ö²éѯÖÐʹÓÃÁÙʱ±íÀ´ÊµÏÖ¡£µ±Ò»¸ö´ó±íÖеÄij¸ö×Ó¼¯ÔÚÒ»¸öÔÚ×ù¹ý³ÌÖÐʹÓöà´Îʱ£¬½¨ÒéʹÓÃÁÙʱ±í¡£ÔÚÕâÖÖÇé¿öÏ£¬ÔÚÁÙʱ±íÖб£³ÖÊý¾ÝµÄ×Ó¼¯£¬ÒÔÔÚËæºóµÄÁ¬½ÓÖÐʹÓã¬ÕâÑùÄÜ´ó´ó¸ÄÉÆÐÔÄÜ¡£»¹¿ÉÒÔÔÚÁÙʱ±íÖд´½¨Ë÷Òý¡£    
   
   
  ´Ó´æ´¢¹ý³ÌÖзµ»Ø½á¹û    
   
  ´Ó´æ´¢¹ý³ÌÖзµ»Ø½á¹ûÓÐÈýÖÖ·½Ê½£º    
   
  1¡¢   ·µ»Ø½á¹û¼¯    
   
  ÕâÊǿͻ§¶ËÓ¦ÓóÌÐò·µ»Ø½á¹ûµÄ×îͨÓõķ½·¨¡£½á¹û¼¯ÊÇͨ¹ýʹÓÃSELECTÓï¾äÑ¡ÔñÊý¾Ý²úÉúµÄ¡£½á¹û¼¯¿ÉÒÔ´ÓÓÀ¾Ã±í¡¢ÁÙʱ±í»ò¾Ö²¿±äÁ¿ÖвúÉú¡£½«½á¹û·µ»Øµ½ÁíÒ»¸ö´æ´¢¹ý³Ì²»ÊÇÒ»ÖÖÓÐЧµÄ·½·¨¡£´æ´¢¹ý³Ì²»ÄÜ·ÃÎÊÁíÒ»¸ö´æ´¢¹ý³Ì½¨Á¢µÄ½á¹û¼¯¡£    
   
  ÀýÈç´ÓÓÀ¾Ã±íÖзµ»Ø½á¹û¼¯£º    
   
  USE   pubs    
   
  GO    
   
 


Ïà¹ØÎĵµ£º

×Ô¼ºÐ´µÄoracle dbms_sql º¯Êý°üÀý×Ó

create or replace procedure pro_insert_dbms
is
cid number;
cid_DDL number;
selectsql varchar2(1000);
ddlsql    varchar2(1000);
row_count number;
nofrows   integer;
lrowid                & ......

SQL 2000 ·ÖÒ³

SELECT TOP 10 *
from HumanResources.Employee
WHERE EmployeeID NOT IN (SELECT TOP 0 EmployeeID from HumanResources.Employee ORDER BY EmployeeID desc)
ORDER BY EmployeeID desc
—————————————————&md ......

½«Êý¾Ý¿âµÄSQL½Å±¾Îļþµ¼Èëµ½oracleÖÐ

#1. Ê×ÏÈÒÔ¹ÜÀíÔ±µÄÉí·ÝµÇ¼µ½oracleϵͳÖÐ
cmd;
sqlplus sys/sys as sysdba;
#2.´´½¨Óû§test,ÃÜÂëΪtest
create user test identified by test;
#3.´´½¨±í¿Õ¼ä,ÔÚDÅÌϽ¨Á¢50mµÄ±í¿Õ¼ädata_dbf
create tablespace ts_tablespace datefile 'D:\data_dbf' size 50m;
#4.ΪÓû§·ÖÅä±í¿Õ¼ä
alter user test default t ......

MySQLµ¼Èë/µ¼³ö.sqlÎļþ


µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
    mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
    mysqldump -u root -p transfer_server_db devi ......

sqlǶÌ××Ó²éѯ

×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔ­Ôò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷ SELECT Óï¾äµÄ×îºó¡£
ORDER BY ×Ó¾ä¿ÉÒÔʹÓ㬲¢ÇÒÔÚ½øÐÐ Top-N ·ÖÎöʱÊDZØÐëµÄ¡£
3.ÔÚ×Ó² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ