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

¡¾ÔÓ¼Ç ¹ØÓÚ·ÃÎÊ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_¿ªÍ· ʹÓô«Èë²ÎÊý»òÕß²»Ê¹Óà ¿ÉÒÔ·µ»ØÏµÍ³ÐÅÏ¢ µ«ÊÇȱµãÊÇÎÞ·¨¿ØÖÆ·µ»ØÐÅÏ¢µÄÁ¿.


Ïà¹ØÎĵµ£º

sql server 2000 Êý¾Ý¿âÔ¶³Ì±¸·Ý

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Ö®·Ö²¼Ê½ÊÂÎñ

SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
 ÊÕ²Ø
--> Title  : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
--> Author : wufeng4552
 
--> Date   : 2009-11-11
 
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
(Ò»)¸ÅÄî:
 
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Serv ......

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 ......

DataGridView¿Ø¼þÓëSQL¶à±íÁ¬½Ó~£¡

Ò»¸ö×î¼òµ¥µÄ´úÂë¶Î£º
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 ......

sqlǶÌ××Ó²éѯ

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