ÀûÓÃͬÒå´Ê¼ò»¯SQL Server 2005¿ª·¢
Ò». ÒýÑÔ
¡¡¡¡Èç¹ûÄãÔø¾Ê¹ÓÃSQL Server¿ª·¢¹ýÈκÎÈí¼þ£¬ÄÇôÄã¿Ï¶¨»áϰ¹ßÓÚʹÓÃËIJ¿·Ö±êʶ·ûÀ´²Î¿¼Ò»¸ö¶ÔÏó£º
[[[server.][database].][schema_name].]object_name
¡¡¡¡ÕýÈçÉÏÃæµÄ·½À¨ºÅËùÏÔʾµÄ£¬¸ÃÓï·¨µÄ²»Í¬²¿·Ö¿ÉÒÔ±»ºöÂÔ£¬Ö»ÒªÄãÌṩ×ã¹»µÄ±í´ïÀ´ÎÞ¶þÒ嵨±êʶÄãµÄ¶ÔÏó¼´¿É¡£ÀýÈ磬ÏÂÃæËùÓÐÕâЩ±í´ï¶¼¿ÉÄܲο¼ÏàͬµÄ¶ÔÏó£º
Server1.AdventureWorks.Production.ProductCategory
AdventureWorks.Production.ProductCategory
AdventureWorks..ProductCategory
ProductCategory
¡¡¡¡ÔÚ´ó¶àÊýÇé¿öÏ£¬Äã¿ÉÒÔ½öʹÓÃÈý²¿·ÖÃû×Ö¶øºöÂÔ·þÎñÆ÷Ãû-³ý·ÇÄãÊÇÔÚ´¦ÀíÔÚÒ»¸öÁ¬½ÓµÄ·þÎñÆ÷ÉϵĶÔÏó¡£Ä¬ÈÏÇé¿öÏ£¬ËùÓжÔÏóµÄÉÏÏÂÎͼÊDZ¾µØÊý¾Ý¿â-ÄãµÄSQLÓï¾äÔÚÆäÖÐÖ´ÐС£µ«ÊÇ£¬ÓÐЩÇé¿öÏ£¬»òÕ߸üΪ׼ȷµØËµ£¬Äã±ØÐëʹÓÃÕâÕû¸öËIJ¿·ÖÃüÃû£¨»ò³Æ×÷Ò»ÖÖÈ«³ÆÏÞ¶¨Ãû£©¡£µ«ÊÇ£¬ÔÚSQL Server 2005ÖУ¬ÕâÖÖÇé¿öÓÐËù¸Ä±ä¡£
¡¡¡¡¶þ. ÊìϤͬÒå´Ê
¡¡¡¡SQL Server 2005ÒýÈëÁËÒ»¸öͬÒå´ÊµÄ¸ÅÄÕâÊÇÒ»¸öµ¥²¿·ÖµÄÃû×Ö£¬Ëü¿ÉÒÔÌæ»»ÔÚÐí¶àSQLÓï¾äÖеÄÒ»¸öÁ½¡¢Èý»òËIJ¿·ÖµÄÃû×Ö¡£Ê¹ÓÃͬÒå´Ê¿ÉÒÔÈÃÄã¼õÉÙÊäÈ룬¶øÇÒ»¹ÄÜÌṩһ¸ö³éÏó²ãÀ´ÎªÄã±£»¤µ×²ã¶ÔÏóµÄ¸Ä±ä¡£ÎªÁËÀí½âÆä¹¤×÷ÔÀí£¬ÈÃÎÒÃÇÏÈ¿´Ò»Ï´´½¨Í¬Òå´ÊµÄÓï·¨¡£ÏÂÃæÊÇCREATE SYNONYMÓï¾äµÄÓï·¨£º
CREATE SYNONYM [schema_name.]synonym_name FOR object_name
¡¡¡¡ÔÚ´Ë£¬object_nameÊÇÒ»¸öSQL Server¶ÔÏó(È«³ÆÏÞ¶¨ÒѾ×ãÒÔÄܹ»±êʶ³öÕâ¸ö¶ÔÏó)µÄÃû×Ö£¬¶øsynonym_nameÊÇÄãÏ븳¸øËüµÄÐÂÃû×Ö¡£Èç¹ûÄã²»ÏëΪͬÒå´ÊÖ¸¶¨Ò»ÖÖģʽ£¬ÄÇôSQL ServerʹÓõ±Ç°µÄÓû§µÄĬÈÏģʽ¡£µ±Äã´´½¨Í¬Òå´Êʱ£¬ÏàÓ¦µÄ¶ÔÏó²»ÐèÒª´æÔÚ£¬ÒòΪͬÒå´ÊÊdzٰ󶨵ģºµ±Äãʵ¼ÊÉÏʹÓÃͬÒå´Êʱ£¬SQL Server½ö½ö¼ì²é»ù¶ÔÏó¡£
¡¡¡¡ÀýÈ磬ÔÚAdventureWorksʾÀýÊý¾Ý¿âÖУ¬Äã¿ÉÒÔÒÔÏÂÁз½Ê½´´½¨Ò»¸öͬÒå´Ê£º
CREATE SYNONYM ProdCat
FOR AdventureWorks.Production.ProductCategory
¡¡¡¡Ö®ºó£¬Äã¿ÉÒÔ¼ÌÐøÊ¹ÓÃÔÚSQLÓï¾äÖеÄͬÒå´ÊÁË¡£ÀýÈ磺
SELECT * from ProdCat
¡¡¡¡Í¼1ÏÔʾ³öÏàÓ¦µÄ½á¹û£º
¡¡¡¡µ±ÄãʹÓÃÍêÒ»¸öͬÒå´Êºó£¬Äã¿ÉÒÔʹÓÃDROP SYNONYMÓï¾äÀ´È¥µôËü£¬Ëü¾ßÓÐÄãÆÚÍûµÄÓï·¨¸ñʽ£º
DROP SYNONYM [schema_name.]synonym_name
Èý. ¼¸µãϸ½Ú
¡¡¡¡µ±È»£¬¶ÔÓÚͬÒå´ÊµÄʹÓÃÉÏÒ²´æÔÚһЩÏÞÖÆ¡£¶ÔÓÚ³õѧÕßÀ´Ëµ£¬Äã²»ÄÜΪÈκζ«Î÷¶¼´´½¨Ò»¸öͬÒå´Ê¡£SQL Server 2005±ÈÒÔǰÒýÈëÁ˸ü¶àµÄ¶ÔÏ󣬵«ÊÇͬÒå´Ê½öÏÞÓÚÓ¦ÓÃÓÚºËÐÄ×îÓÐÓõÄһЩ¶ÔÏóÖУº
Ïà¹ØÎĵµ£º
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2.²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4.²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
²é¿´Êý¾Ý¿â·þÎñÆ÷ÃûºÍʵÀýÃû
print ''Server Name.... ......
-- ʾÀýÒ», ʹÓÃÖ¤Êé¼ÓÃÜÊý¾Ý.
-- ½¨Á¢²âÊÔÊý¾Ý±í
CREATE TABLE tb(ID int IDENTITY (1,1),data varbinary (8000));
GO
-- ½¨Á¢Ö¤ÊéÒ», ¸ÃÖ¤ÊéʹÓÃÊý¾Ý¿âÖ÷ÃÜÔ¿À´¼ÓÃÜ
CREATE CERTIFICATE Cert_Demo1
WITH
SUBJECT = N'cert1 encryption by database master key' ,
START_DATE = ......
×÷ÖÐÊý¾Ý¿â¾³£³ö´íËÀËø£¬²¢ÇÒ»¹ÒªÒªÇó½â¾öµ±Ç°µÄËÀËø£¬ÎÊÌâ¶à¶à£»
²ÎÕÕCSDN£¬Öйú·ç(Roy)һƪËÀËøÎÄÕ²¢¸Ä½øÁËÏ£»
/***********************************************************************************************************************
ÕûÀíÈË£ººÚľÑÂÉϵÄÎÏÅ£(lenolotus) ÈÕÆÚ:2009.04.28
************ ......
ÉÏ»ØÎÒÃÇ˵µ½ÆÀ¹ÀÒ»ÌõÓï¾äÖ´ÐÐЧÂÊÖ÷Òª¿´Âß¼ IO £¨É¶ÊÇÂß¼ IO £¬É¶ÊÇÎïÀí IO ¼ûÁª»úÎĵµ£©£¬Õâ´ÎÎÒÃǼÌÐø¡£
ÎÒÃÇÏÈ˵˵£¬·µ»Ø¶àÐнá¹ûʱ£¬ÎªÊ²Ã´ SQLServer ÓÐʱ»áÑ¡Ôñ index seek £¬ÓÐʱ»áÑ¡Ôñ index scan ¡£
ÒÔ nonclustered index ΪÀý˵Ã÷¡£
ÏñËùÓеÄË÷Òý B Ê÷Ò»Ñù£¬·Ç¾Û¼¯Ë÷ÒýÊ÷Ò²°üÀ¨ÍêÈ«ÓÉË÷ÒýÊý¾Ý×é³ÉµÄ¸ù½ ......