SQL Server2005±í·ÖÇø
---//´´½¨·ÖÇø
CREATE PARTITION FUNCTION MarketInfo_Bak_partfunc(int)
AS RANGE RIGHT
FOR VALUES (10000,25000,40000)
--//´´½¨·ÖÇø¼Ü¹¹
CREATE PARTITION SCHEME MarketInfo_Bak_partscheme
¡¡¡¡AS PARTITION MarketInfo_Bak_partfunc
¡¡¡¡TO (fg1, fg2, fg3, fg4) --//fg1...fg4Îļþ×éÃû
--//¶Ô±í½øÐзÖÇø
CREATE TABLE ±íÃû(FirstName nvarchar(40), LastName nvarchar(40), Number int)
¡¡¡¡ON MarketInfo_Bak_partscheme (Number)
----///////ʵ¼ù²Ù×÷
ÕâÀï½øÐжÔsql server 2005±í·ÖÇøÒ»´Îʵ¼ù²Ù×÷£¬Õâ´ÎÊý¾ÝµÄǰÌ᣺ÓÐÕâôһ¸öLog±í£¬Êý¾ÝÁ¿´ó¸ÅÊÇÁ½Ç§¶àÍòÌõ£¬Ö»±£ÁôÁù¸öÔÂÒÔÄÚµÄÊý¾Ý¡£±íÀïÓÐÁÐLogTime£¬¼Ç¼ÈÕÖ¾µÄʱ¼ä¡£
·ÖÎö£º¶ÔLog·Ö³É6¸öÇø£¬·Ö±ðΪPG1£¬PG2£¬PG3...PG6£»Ã¿¸öÇøÖ»´æ´¢Ò»¸öÔ·ݵÄÊý¾Ý£¬ÒÔLogTimeΪ·Ö½çµã(ÍÆ¼öÕâ6¸öÇø·Ö±ð·ÅÔÚ²»Í¬µÄÎïÀíÓ²ÅÌÉÏ)
²½Ö裺
1.ΪÊý¾Ý¿â[TestDB]Ìí¼Ó6¸öÎļþ×é¼°Îļþ×éÂß¼Ãû³Æ£¬É趨Îļþ×é´æ·ÅµÄλÖá£ÎÒÃÇÔÝʱÉ趨ΪPG1,G2…PG6£¬Èç¹ûÎÒÃǵÄÊý¾Ý¿â´æ´¢×ŽñÄê1-6Ô·ݵÄÊý¾Ý£¬ÔòÎÒÃǵÄPG1¾Í´æ·Å1Ô·ݵÄÊý¾Ý£¬PG2¾Í´æ·Å2Ô·ݵÄÊý¾Ý£¬ÒÔ´ËÀàÍÆ£¬PG6¾Í´æ·Å6Ô·ݵÄÊý¾Ý¡£
Alter DATABASE [TestDB]
Add FILEGROUP [PG1]
Alter DATABASE [TestDB]
Add FILE( NAME = N'PG1', FILENAME = N'E:\Database\PG1.ndf' , SIZE = 5242880KB , MAXSIZE = UNLIMITED, FILEGROWTH = 102400KB ) To FILEGROUP [PG1]
ÉÏÃæÖ»Áгö´´½¨PG1µÄ´úÂ룬ÒÀ´Î´´½¨PG2,PG3...PG6
2.´´½¨·ÖÇøº¯Êý:
Create Partition Function [Data Partition Rang
Ïà¹ØÎĵµ£º
SQL×¢Èë¹¥»÷·À·¶¼¼ÇÉ
Ò»°ãµÄSQL×¢Èë¹¥»÷¶¼ÊÇͨ¹ý¹¹½¨Ò»Ìõ¸´ÔÓµÄsqlÓï¾ä£¬
ͨ¹ýÍøÒ³Â©¶´À´Ö´ÐÐsqlÓï¾ä£¬´ïµ½¹¥»÷Êý¾Ý¿âµÄÄ¿µÄ¡£
Èçͨ¹ýÎÄÕÂIDÀ´²éѯijһƪÎÄÕµÄÍøÒ³£¬
ͨ³£²ÉÓõÄsqlÓï¾äΪ£º
sql="select top 1 * from articles where articId="&request("id")
ÄÇô¿ÉÒÔ¼òµ ......
/*
--×÷ÓãºSQL SERVER²Ù×÷ACCESSµÄ´æ´¢¹ý³Ì
----------------------Ó÷¨-------------------------------
--´´½¨±ítc
exec sp_operate_access 'create table tc(id int)','c:\db1.mdb'
go
--ÔÚtc±í²åÈëÊý¾Ý
exec sp_operate_access 'insert into tc(id) values(1)','c:\db1.mdb'
go
--ɾ³ýtc±íµÄÊý¾Ý
exec sp_op ......
ʹÓÃPL/SQL developerÔ¶³Ì·ÃÎÊoracleÊý¾Ý¿âʱ£¬Ê×ÏÈҪȷ¶¨±¾»úÖÐ×°ÓÐoracle¿Í»§¶Ë¡£Ä¿Ç°»¹²»ÖªµÀÄÄÀïµ¥¶ÀµÄoracle¿Í»§¶Ë°²×°°ü¡££¨ÒòΪÎÒÓõÄÊÇoracle10g£¬oracle10g°²×°µÄ¹ý³ÌÖÐûÓÐÌØ¶¨µÄ¿Í»§¶ËÑ¡ÏËùÒÔÎÒÒ»°ã¶¼ÊÇÔÚ±¾»úÓð²×°oracleËùÓй¦ÄÜ£©
ÔÚ±¾»ú°²×°ºÃoracle¿Í»§¶Ëºó£¬ÎÒÃÇÔÚ±¾»ú(¼´¿Í»§¶Ë)µÄoracleµÄ°²×°Ä¿Â¼Ï ......
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷Éϰ²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin200 ......