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

SQL Server2005 SynonymµÄʹÓÃ

--> Title  : SQL Server2005 SynonymµÄʹÓÃ
--> Author : wufeng4552
--> Date   : 2009-10-30
1.SynonymµÄ¸ÅÄî
¡¡  Synonym£¨Í¬Òå´Ê£©ÊÇSQL Server 2005µÄÐÂÌØÐÔ¡£¿ÉÒÔ¼òµ¥µÄÀí½âSynonymΪÆäËû對ÏóµÄ±ðÃû¡£
語·¨
CREATE SYNONYM [ schema_name_1. ] synonym_name FOR < object >
< object > :: =
{
    [ server_name.[ database_name ] . [ schema_name_2 ].| database_name . [ schema_name_2 ].| schema_name_2. ] object_name
}
ÔÚ½¨Á¢Í¬義×Ö時£¬»ùµ×Îï¼þ²»ÐèÒª´æÔÚ¡£ÔÚ執ÐÐ階¶Î£¬SQL Server 會檢²é»ùµ×Îï¼þÊÇ·ñ´æÔÚ¡£
¸÷參數º­義ÈçÏÂ:
schema_name_1 :Ö¸¶¨½¨Á¢Í¬義×ÖµÄ結構ÃèÊö¡£Èç¹ûδָ¶¨ schema£¬SQL Server 2005 會ʹÓÃĿǰʹÓÃÕßµÄ預設結構ÃèÊö¡£
synonym_name :這ÊÇÐÂͬ義×ÖµÄÃû稱¡£
server_name :這ÊÇ»ùµ×Îï¼þËùÔÚµÄËÅ·þÆ÷Ãû稱¡£
database_name :這ÊÇ»ùµ×Îï¼þËùÔÚµÄ資ÁÏ庫Ãû稱¡£Èç¹ûδָ¶¨ database_name£¬¾Í會ʹÓÃĿǰ資ÁÏ庫µÄÃû稱¡£
schema_name_2 :這ÊÇ»ùµ×Îï¼þµÄ結構ÃèÊöÃû稱¡£Èç¹ûδָ¶¨ schema_name£¬¾Í會ʹÓÃĿǰʹÓÃÕßµÄ預設結構ÃèÊö¡£
object_name :這ÊÇͬ義×Ö參¿¼µÄ»ùµ×Îï¼þÃû稱¡£
×¢:
ÈôҪʹÓøø¶¨¼Ü¹¹´´½¨Í¬Òå´Ê£¬Óû§±ØÐëÂú×ãÒÔÏÂÌõ¼þ£º
(1)ÓµÓд˼ܹ¹»ò¾ßÓÐ ALTER SCHEMA ȨÏÞÒÔ
(2)¾ßÓÐ CREATE SYNONYM ȨÏÞ¡£
(3)ÊÇ db_owner µÄ³ÉÔ±¡£
(4)ÊÇ db_ddladmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±
¿ÉÒÔΪÏÂÁжÔÏóÀàÐÍ´´½¨Í¬Òå´Ê£º
³ÌÐò¼¯ (CLR) ´æ´¢¹ý³Ì; ³ÌÐò¼¯ (CLR) ±íÖµº¯Êý
³ÌÐò¼¯ (CLR) ±êÁ¿º¯Êý; ³ÌÐò¼¯¾ÛºÏ (CLR) ¾ÛºÏº¯Êý
¸´ÖÆÉ¸Ñ¡¹ý³Ì; À©Õ¹´æ´¢¹ý³Ì
SQL ±êÁ¿º¯Êý;SQL ±íÖµº¯ÊýSQL ÄÚÁª±íÖµº¯Êý;
SQL ´æ´¢¹ý³ÌÊÓͼ; ±í(Óû§¶¨Òå)
2.SynonymµÄʵ¼ÊÓ¦ÓÃ
ÔÚÄãµÄ³ÌÐò·¢²¼µÄʱºò£¬ÄãͻȻ·¢ÏÖÄãÐèÒª¸ü¸Äij¸ö±íÃû£¬»ò×Ö¶ÎÃû¡£¶øÄãµÄ³ÌÐòÒѾ­²»¿ÉÄÜÐ޸ġ£Õâʱ£¬Ôõô°ìÄØ£¿ÄǾʹ´½¨Synonym°É¡£µ±È»£¬ÔÚsql2000ʱ´ú£¬Äã¿ÉÒÔʹÓÃviewÀ´×öÕâ¸öÊÂÇ飬»òsprocs»òudfµÈ¡£µ«SynonymÓÐÆäËüËù²»ÄܵŦÄÜ£¬ÄǾÍÊÇ¿çÊý¾Ý¿â£¬¿ç·þÎñÆ÷¡£
-----------------------


Ïà¹ØÎĵµ£º

SQL ServerÈÕÆÚ´¦ÀídatetimeºÍdateÖ®¼äµÄÏ໥ת»»

 
ÈÕÆÚÀàÐ͸ÅÊö
SQL ServerÖеÄÈÕÆÚÀàÐͰüÀ¨datetimeºÍsmalldatetime£¬½öÄÜ´¦Àí¿ÉÒÔʶ±ðΪ1753Äê¡«9999Äê¼äµÄÈÕÆÚµÄÖµ£¬Ã»Óе¥¶ÀµÄÈÕÆÚÐÍ»òʱ¼äÐÍ¡£
1£®datetime
datetimeÀàÐÍ´¦Àí´Ó1753Äê1ÔÂ1ÈÕ¡«9999Äê12ÔÂ31ÈÕµÄÈÕÆÚºÍʱ¼äÊý¾Ý£¬¾«È·¶ÈΪ°Ù·ÖÖ®ÈýÃë¡£
¼´£º¶ÔÓÚ0.000¡«0.001¡¢0.009µÄÈÕÆÚÖµ£¬µ÷ÕûΪ0.000£»¶ÔÓÚ ......

sql ·þÎñÆ÷ÎÞ·¨Æô¶¯£¬½â¾ö·½°¸

 
¶ÔÓÚ·þÎñÆ÷ÉÏÊý¾ÝµÄ±¸·Ý¹¤×÷ÊÇÍø¹ÜÔ±ÈÕ³£¹¤×÷ÖÐ×îÖØÒªµÄ¹¤×÷Ö®Ò»£¬SQLServerAgent·þÎñʹµÃÎÒÃÇ¿ÉÒÔÓÃSQLÉϵēÊý¾Ý¿âά»¤¼Æ»®”¹¦
ÄÜÀ´×Ô¶¯±¸·ÝÊý¾Ý£¬µ«×î½üÎÒ·¢ÏÖ·þÎñÆ÷ÉÏSQLServerAgent·þÎñÎÞ·¨Æô¶¯ÁË£¬»ØÏë×î½üËù×öµÄ²Ù×÷£¬Ô­À´ÊÇÒòΪÎÒ°ÑSQLÖÐ
Builtin/AdministratorsÕâ¸öÕʺŵķþÎñÆ÷·ÃÎÊȨÏÞ½ûÖ¹ ......

SQL SERVER²Ù×÷ACCESSµÄ´æ´¢¹ý³Ì

/*
--×÷Óãº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 ......

SQLº¯ÊýÖ®ËÄÉáÎåÈë

SQLº¯ÊýÖ®ËÄÉáÎåÈ루ת×Ôhttp://ln1058.javaeye.com/blog/191502£©
ÎÊÌâ1£º
SELECT CAST('123.456' as decimal) ½«»áµÃµ½ 123£¨Ð¡ÊýµãºóÃæµÄ½«»á±»Ê¡ÂÔµô£©¡£
Èç¹ûÏ£ÍûµÃµ½Ð¡ÊýµãºóÃæµÄÁ½Î»¡£
ÔòÐèÒª°ÑÉÏÃæµÄ¸ÄΪ
SELECT CAST('123.456' as decimal(38, 2)) ===>123.46
×Ô¶¯ËÄÉáÎåÈëÁË£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ