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¡£
Óô´½¨¸Ã¶ÔÏóµÄÓû§ÃûÏÞ¶¨¡£
Ïà¹ØÎĵµ£º
......
/***************************************************
×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
ÈÕÆÚ£º2009.12.19
×¢£º תÔØÇë±£Áô´ËÐÅÏ¢
&nb ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
orACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ ......
¡¡SQLÖÐÓÐËÄÖÖ»ù±¾µÄDML²Ù×÷£ºINSERT£¬SELECT£¬UPDATEºÍDELETE¡£
INSERTÓï¾ä
¡¡¡¡Óû§¿ÉÒÔÓÃINSERTÓï¾ä½«Ò»ÐмǼ²åÈëµ½Ö¸¶¨µÄÒ»¸ö±íÖС£ÀýÈ磬Ҫ½«¹ÍÔ±John SmithµÄ¼Ç¼²åÈëµ½±¾ÀýµÄ±íÖУ¬¿ÉÒÔʹÓÃÈçÏÂÓï¾ä£º
¡¡¡¡INSERT INTO EMPLOYEES VALUES
¡¡¡¡ ('Smith','John','1980-06-10',
¡¡¡¡ 'Los Angles',16,45000);
¡¡ ......
Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
·¢²¼Ê±¼ä£º2003.01.14 10:09 À´Ô´£ºÈüµÏÍø ×÷ÕߣºÍõ¿Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......