¡¾ÔÓ¼Ç ¹ØÓÚ·ÃÎÊ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),'-','') --»ñµÃÈÕÆÚ ......
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
ÊÕ²Ø
--> Title : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
--> Author : wufeng4552
--> Date : 2009-11-11
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
(Ò»)¸ÅÄî:
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Serv ......
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 ......
Ò»¸ö×î¼òµ¥µÄ´úÂë¶Î£º
string sql = string.Format("select Consult_Info.CName,Consult_Record.RTime,Consult_Record.RContent,Emp_Info.EName,CMode.Mode from Consult_Info inner join Consult_Record on(Consult_Info.CID = Consult_Record.CID) inner join Emp_Info on(Emp_Info.EID=Consult_Record.EID) inner join ......
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷ SELECT Óï¾äµÄ×îºó¡£
ORDER BY ×Ó¾ä¿ÉÒÔʹÓ㬲¢ÇÒÔÚ½øÐÐ Top-N ·ÖÎöʱÊDZØÐëµÄ¡£
3.ÔÚ×Ó² ......