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