SQLÖÐdbo.
Êý¾Ý¿âËùÓÐÕß (DataBase Owner)
dbo ÊǾßÓÐÔÚÊý¾Ý¿âÖÐÖ´ÐÐËùÓлµÄ°µÊ¾ÐÔȨÏÞµÄÓû§¡£½«¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±¶¼Ó³É䵽ÿ¸öÊý¾Ý¿âÄÚ³ÆÎª dbo µÄÒ»¸öÌØÊâÓû§ÉÏ¡£ÁíÍ⣬Óɹ̶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±´´½¨µÄÈκζÔÏó¶¼×Ô¶¯ÊôÓÚ dbo¡£
ÀýÈ磬Èç¹ûÓû§ Andrew Êǹ̶¨·þÎñÆ÷½ÇÉ« sysadmin µÄ³ÉÔ±£¬²¢´´½¨±í T1£¬Ôò±í T1 ÊôÓÚ dbo£¬²¢ÒÔ dbo.T1 ¶ø²»ÊÇ Andrew.T1 ½øÐÐÏÞ¶¨¡£Ïà·´£¬Èç¹û Andrew ²»Êǹ̶¨·þÎñÆ÷½ÇÉ« sysadmin µÄ³ÉÔ±£¬¶øÖ»Êǹ̶¨Êý¾Ý¿â½ÇÉ« db_owner µÄ³ÉÔ±£¬²¢´´½¨±í T1£¬Ôò T1 ÊôÓÚ Andrew£¬²¢ÏÞ¶¨Îª Andrew.T1¡£¸Ã±íÊôÓÚ Andrew£¬ÒòΪ¸Ã³ÉԱûÓн«±íÏÞ¶¨Îª dbo.T1¡£
ÎÞ·¨É¾³ý dbo Óû§£¬ÇÒ´ËÓû§Ê¼ÖÕ³öÏÖÔÚÿ¸öÊý¾Ý¿âÖС£
Ö»ÓÐÓÉ sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«³ÉÔ±£¨»ò dbo Óû§£©´´½¨µÄ¶ÔÏó²ÅÊôÓÚ dbo¡£ÓÉÈÎºÎÆäËûÒ²²»ÊÇ syadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«³ÉÔ±µÄÓû§£¨°üÀ¨ db_owner ¹Ì¶¨Êý¾Ý¿â½ÇÉ«³ÉÔ±£©´´½¨µÄ¶ÔÏó£º
ÊôÓÚ´´½¨¸Ã¶ÔÏóµÄÓû§£¬¶ø²»ÊÇ dbo¡£
Óô´½¨¸Ã¶ÔÏóµÄÓû§ÃûÏÞ¶¨¡£
Ïà¹ØÎĵµ£º
ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ× ......
×î½ü¹«Ë¾ÔÚÕÐÈË£¬Í¬ÊÂÎÊÁ˼¸¸ö×ÔÈÏΪÊý¾Ý¿â¿ÉÒÔµÄӦƸÕß¹ØÓÚ¿âÁ¬½ÓµÄÎÊÌ⣬»Ø´ð²»¾¡ÀíÏë¡«
ÏÖÔÚÔÚÕâдд¹ØÓÚËüÃǵÄ×÷ÓÃ
¼ÙÉèÓÐÈçÏÂ±í£º
Ò»¸öΪͶƱÖ÷±í£¬Ò»¸öΪͶƱÕßÐÅÏ¢±í¡«¼Ç¼ͶƱÈËIP¼°¶ÔӦͶƱÀàÐÍ£¬×óÓÒÁ¬½Óʵ¼Ê˵ÊÇÎÒÃÇÁªºÏ²éѯµÄ½á¹ûÒÔÄĸö±íΪ׼¡«
1£ºÈçÓÒ½ÓÁ¬ right join »ò right outer join£º
ÎÒÃÇÒÔÓÒ±ß ......
Î壺 ORACLEµÄÖ´Ðмƻ®
±³¾°ÖªÊ¶£ºÎªÁ˸üºÃµÄ½øÐÐÏÂÃæµÄÄÚÈÝÎÒÃDZØÐëÁ˽âһЩ¸ÅÄîÐÔµÄÊõÓ
¹²ÏísqlÓï¾ä
ΪÁ˲»Öظ´½âÎöÏàͬµÄSQLÓï¾ä(ÒòΪ½âÎö²Ù×÷±È½Ï·Ñ×ÊÔ´£¬»áµ¼ÖÂÐÔÄÜϽµ)£¬ÔÚµÚÒ»´Î½âÎöÖ®ºó£¬ORACLE½«SQLÓï¾ä¼°½âÎöºóµÃµ½µÄÖ´Ðмƻ®´æ·ÅÔÚÄÚ´æÖС£Õâ¿éλÓÚϵͳȫ¾ÖÇøÓòSGA(system global are ......
RowidµÄ¸ÅÄ
rowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬ÔòrowidÔÚ¸ÃÐеÄÉúÃüÖÜÆÚÄÚÊÇΨһµÄ£¬¼´ ......