¡¾ÔÓ¼Ç ¹ØÓÚ·ÃÎÊSQL SERVER2005 µÄϵͳ¶ÔÏó¡¿
SQL SERVERά»¤×ÅÒ»×é±í,´æ´¢ËùÓжÔÏó,Êý¾ÝÀàÐÍ,Ô¼Êø,ÅäÖÃÑ¡Ïî¼°SQLÄÜ·ÃÎʵÄ×ÊÔ´,ÕâЩ±í³ÆÎªÏµÍ³Ä¿Â¼(ϵͳ»ù±¾±í).
ÎÒÃÇÔÚSQL SERVER2005ÀïÓкܶàÖÖ·½·¨À´·ÃÎÊÔªÊý¾Ý.Ò»°ãÊÇʹÓÃĿ¼ÊÓͼºÍϵͳº¯Êý,ÐÅÏ¢¼Ü¹¹ÊÓͼֻÄܰüº¬ËüÃÇÈ«²¿µÄÒ»²¿·Ö.
×î¼Ñ½Ó¿Ú£ºÄ¿Â¼ÊÓͼ
Ŀ¼ÊÓͼ¶¼Î»ÓÚSYS¼Ü¹¹ÏÂ,°üÀ¨Á˶¯Ì¬¹ÜÀí¶ÔÏó(DMVºÍDMF)ºÍ¼æÈÝÐÔÊÓͼ¡£
¼æÈÝÐÔÊÓͼÊÇΪÁËÌṩÓû§ÄܼÌÐø·ÃÎÊSQL2000µÄϵͳ±íµÄÒ»¸ö×Ó¼¯(δÀ´°æ±¾Ò²Ðí»á±»ÒƳý)
ËüÌØµã1:ËüµÄÃû³Æ¸úSQL2000ÀïÔÀ´µÄϵͳ±íÊÇÒ»ÑùµÄ(±ÈÈçsysobjects sysindex),µ±È»²éѯËûÃǵõ½µÄ½á¹û²»ÍêȫһÑù£»
ÌØµã2:Ëû²»°üº¬¹ØÓÚ2005ÐÂÌØÐÔµÄһЩÁÐ(±ÈÈç·ÖÇø partitioning)
ÌØµã3:Ö»ÄÜÔÚMASTERÊý¾Ý¿âÏÂÔËÐÐ(Ö»Õë¶ÔÊÔÓðæ)
ÆäʵËùνĿ¼ÊÓͼÎÒÀí½âΪ2000µÄϵͳ±íµÄÏêϸ·Ö½â ²¢ÇÒÔö¼ÓÁ˺ܶàй¦ÄÜÏÔʾµÄÁÐÄÚÈÝ.
±ÈÈçĿ¼ÊÓͼ:sys.objects ==>sys.tables ==>sys.columns ÔÚsys.tables ÀïÃæÏÔʾÁËsys.objectsµÄËùÓÐÁв¢ÇÒ»¹ÓйØÓÚTable±¾ÉíµÄÁÐ,µ«ÊÇsys.tablesÐÐÊý¾ÍûÓоÍÉÙÓÚsys.objectsµÄÐÐÊý,ËüÖ»°üº¬¹ØÓÚTableµÄÐÐ
Ò»¾ä»°¸ÅÀ¨¾ÍÊÇ˵:»ù´¡ÊÓͼ°üº¬ÁËÁеÄ×Ó¼¯ºÍÐеij¬×Ó¼¯,¶øÉú³ÉÊÓͼ°üº¬ÁËÁеij¬×Ó¼¯ºÍÐеÄ×Ó¼¯.(ÉÏÃæµÄÁÐ×ÓÖÐ sys.objects ÊÇ»ù´¡ÊÓͼ sys.tables ÊÇÉú³ÉÊÓͼ)
ÐÅÏ¢¼Ü¹¹ÊÓͼ:
´ó¶àÊýͨ¹ýĿ¼ÊÓͼµÃµ½µÄÐÅÏ¢¶¼¿ÉÒÔͨ¹ýÐÅÏ¢¼Ü¹¹ÊÓͼµÃµ½¡£µ«»¹ÊÇÓÐÉÙÁ¿Ìض¨¹¦ÄÜÐÅϢûÓÐÔÚÆäÖÐ.
Ñ¡ÔñµÄʹÓÃʱ»ú:ÎÒÃǵĴúÂëÒªÇóÓбȽϺõÄÒÆÖ²ÐÔ;ÏëµÃµ½µÄ¶¼ÊÇһЩ±ê×¼¹¦ÄÜ£¨²»°üÀ¨±ÈÈçË÷Òý Îļþ×é CLR µÈÔªÊý¾Ý£©
ϵͳº¯Êý:
Ö÷ÒªÊÇһЩÊôÐÔº¯Êý:SEVERPROPERTY()¡¢COLUMNPROPERTY()¡¢DATABASEPROPERTY()¡¢INDEXPROPERTY()µÈ¡£¾ßÌå²é¿´MSDN
ϵͳ´æ´¢¹ý³Ì:
Ò»°ãÒÔsp_¿ªÍ· ʹÓô«Èë²ÎÊý»òÕß²»Ê¹Óà ¿ÉÒÔ·µ»ØÏµÍ³ÐÅÏ¢ µ«ÊÇȱµãÊÇÎÞ·¨¿ØÖÆ·µ»ØÐÅÏ¢µÄÁ¿.
Ïà¹ØÎĵµ£º
EXEC sp_configure 'show advanced options', 1
declare @strdirname varchar(100)
declare @RemotePathstr varchar(100)
declare @LocalPathstr varchar(100)
declare @DBName char(50)
declare @sql varchar(100)
set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','') --»ñµÃÈÕÆÚ ......
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 ......
Äê³õµÄʱºòÒ»Ö±ÔÚ×öÒ»¸öÍøÕ¾MSSQL2000->MySQL5µÄÇ¨ÒÆ¹¤×÷£¬ÒòΪ²ÉÓÃÁ˲»Í¬µÄ³ÌÐòϵͳ£¬ËùÒÔÖ÷ÒªÎÊÌâÔÚÊý¾ÝµÄÇ¨ÒÆ¡£ÓÉÓÚ2¸öϵͳÊý¾Ý¿â½á¹¹²îÒì·Ç³£´ó£¬²»·½±ã²ÉÈ¡SQLSERVERÀïµ¼ÈëMYSQLµÄODBCÊý¾ÝÔ´µÄ¹¦ÄÜ£¨Ò²²»ÍƼöÕâô×ö£¬×Ö¶ÎÀàÐ͵Ȳ»Í¬µã»á¸ãËÀÈ˵ġ«£©£¬Òò´Ë¾ÍÔÚWINDOWSÏÂ×Ô¼ºÐ´PHP½Å±¾´ÓSQLSERVERÀï¶ÁÊý¾Ý£¬È»ºó°´ÕÕ ......
×Ô£ºhttp://blog.csdn.net/AJAXBloger/archive/2007/08/29/1764506.aspx
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²é
ѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷
SELECT Óï¾äµÄ×î ......
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷ SELECT Óï¾äµÄ×îºó¡£
ORDER BY ×Ó¾ä¿ÉÒÔʹÓ㬲¢ÇÒÔÚ½øÐÐ Top-N ·ÖÎöʱÊDZØÐëµÄ¡£
3.ÔÚ×Ó² ......