Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá


1. SQLÓÅ»¯µÄÔ­ÔòÊÇ£º
  ½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£ 
  µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺 
  ¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ 
  ¼ì²é×Ó²éѯ  ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½ÓµÄ·½Ê½½øÐÐÖØÐÂÊéд  ......

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

DB2 SQL/XMLʹÓÃ

º¯Êý£º
XMLPARSE£º½âÎö×Ö·û»òÕß´ó¶ÔÏó¶þ½øÖÆÊý¾Ý£¬²úÉúXML
XMLSERIALIZE£º½«XMLֵת»»Îª×Ö·û»òÕß´ó¶ÔÏó¶þ½øÖÆÊý¾Ý
XMLVALIDATE£º¸ù¾ÝXML schemaУÑéXMLÖµµÄÓÐЧÐÔ
XMLEXISTS£º¼ì²âXQueryÊÇ·ñ·µ»Ø½á¹û£¨ÈçÓÉÒ»¸ö»ò¶à¸öÏîËù×é³ÉµÄÐòÁУ©
XMLQUERY£ºÖ´ÐÐÒ»¸öXQuery²¢ÒÔÒ»¸öÐòÁзµ»Ø½á¹û
XMLTABLE£ºÖ´ÐÐÒ»¸öXQuery£¬ÒÔ¹ØÏ ......

hibernateɾ³ý²Ù×÷µÄsqlÓï¾äд·¨

 
µÚÒ»ÖÖ£º
public void deleteUser(String byemail) {
  Session session = getSession();
  Transaction transaction = null;
  String hql = "delete from Register where email=?
";
  try {
   transaction = session.beginTransactio ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ