¹ØÓÚ SQL Server ûÓÐ dbo ȨÏÞµÄÎÊÌâ

·¢²¼Ê±¼ä:2008-11-26 10:25:09   ä¯ÀÀÈËÊý: 480168 ´Î  

¹ØÓÚ sql server Êý¾Ý¿â²éѯÊý¾Ý»òÖ´Ðд洢¹ý³Ìʱ£¬³öÏÖÀàËÆ "ûÓÐdboȨÏÞ"¡¢"ÕÒ²»µ½ dbo.XXX ¶ÔÏó"µÈµÄ½â¾ö·½·¨

1. ³öÏÖÕâ¸öÎÊÌâµÄÔ­ÒòÊÇÒòΪµ±Ç°Á¬½ÓÊý¾Ý¿âµÄµÇ¼Óû§²»ÊÇ dbo ȨÏÞ£¬ËùÒÔ´ËÓû§²»ÄܲÙ×÷ËùÓÐÕßΪ dbo µÄ¶ÔÏó¡£ÎªÊ²Ã´²»¿ª·Å dbo ȨÏÞ£ºÒòΪÈç¹û¿Í»§µÄ³ÌÐòÓÐÎÊÌ⣨±ÈÈçÓÐ×¢Èë©¶´£©¡¢»òÊý¾Ý¿âÃÜÂëй©µÈ£¬Èç¹ûµ±Ç°Óû§ÓÐ dbo ȨÏ޵ϰ£¬»á¸øÊý¾Ý¿â·þÎñÆ÷´øÀ´°²È«Òþ»¼£¬ËùÒÔÎÒ˾µÄÊý¾Ý¿â¶¼²»¿ª·Å dbo ȨÏÞ£¬¶øÎÒÃǸøÓû§¿ª·ÅÁËdatareader¡¢datawriter¡¢ddladmin µÈȨÏÞ£¬ÕâЩȨÏÞÒ»°ãÇé¿öÏÂÊÇ×ã¹»µÄ¡£

2.¡¡Óû§ÔÚ³õʼ»¯Êý¾ÝµÄʱºò£¬±ÈÈçͨ¹ýÆóÒµ¹ÜÀíÆ÷Ö´Ðе¼ÈëÊý¾ÝµÄ SQL £¬»òͨ¹ýÄ³Ð©ÍøÕ¾°²×°³ÌÐò³õʼ»¯µÄʱºò£¬ÕâЩԭʼµÄ³õʼ»¯Êý¾ÝÖеĶÔÏóËùÓÐÕß¿ÉÄÜÊÇ dbo £¬Õ⽫»áµ¼ÖÂÔÚ³õʼ»¯Êý¾Ýºó£¬Êý¾Ý¿âµÄµ±Ç°µÇ¼Óû§Ã»ÓÐȨÏÞ²Ù×÷ÕâЩ¶ÔÏó¡£

3. ¶ÔÓÚÒÔÉÏÎÊÌ⣬½â¾ö·½·¨ÈçÏ£º
¡¡¡¡1. ÔÚÄú¶ÔÊý¾Ý¿âµÄ½á¹¹½øÐÐÁ˸ü¸Äºó£¬Òª×¢ÒâÊý¾Ý¿â¶ÔÏó(ÈçÊý¾Ý±í¡¢´æ´¢¹ý³ÌµÈ)µÄËùÓÐÕßÓ¦¸ÃÊÇÄúµÄÊý¾Ý¿âÓû§Ãû£¬¶ø²»ÊÇ dbo £¬Èç¹ûÄú·¢ÏÖÓÐijЩ¶ÔÏóµÄËùÓÐÕßÊÇ dbo £¬ÕâʱÄúÓ¦¸ÃµÇ¼ÎÒ˾µÄÊý¾Ý¿â¿ØÖÆÃæ°å£¬È»ºóÕÒµ½¡°ÐÞ¸´¶ÔÏóËùÓÐÕß¡±µÄ°´Å¥£¬µã»÷һϾͿÉÒÔ½«ËùÓжÔÏóµÄËùÓÐÕßÉèÖÃΪÄúµÄµ±Ç°µÇ¼Óû§¡£
¡¡¡¡£¨×¢Ò⣺ϵͳ±í¡¢ÏµÍ³´æ´¢¹ý³Ì µÈ²»Óô¦Àí£¬Ö»ÓÐ×Ô¼º½¨Á¢µÄ±í¡¢´æ´¢¹ý³Ì¡¢ÊÓͼµÈ²ÅÒª´¦Àí£©
4. ÔÚÄúµÄ³ÌÐòÖУ¬Òª×¢ÒâÒÔÏ·½Ãæ
¡¡¡¡ÔÚ²éѯ¡¢¸üС¢É¾³ýÊý¾Ý£¬Ö´Ðд洢¹ý³ÌµÈÒ»ÇвÙ×÷ÖУ¬²»ÒªÊ¹Óà "dbo.±íÃû"¡¢"dbo.´æ´¢¹ý³ÌÃû" µÈ½øÐвÙ×÷£¬
¡¡¡¡¶ø¸ÄΪֱ½ÓÓà "±íÃû"¡¢"´æ´¢¹ý³Ì"ÃûµÈ½øÐвÙ×÷£¬¾ÍÊDz»Òª´øÓжÔÏóËùÓÐÕߵIJ¿·Ö£¬È磺
¡¡¡¡select * from dbo.table1 Ó¦¸Ã¸ÄΪ select * from table1
¡¡¡¡¸ü¶àÇë×öÀàËÆÐÞ¸Ä~



ÉÏһƪ£ºÃÀ¹úÐéÄâÖ÷»úµ¼¹º£¡£¡
ÏÂһƪ£ºÀÄÓÃon error resume nextÔì³ÉµÄ¿Õ¼ä±»Í£ÓÃ
ÆæµäÍøÂç.Öйú °æÈ¨ËùÓÐ ©  ÉϺ£ÆæµäÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾ »¦ICP±¸13006046ºÅ ±¾Õ¾³ÌÐò½çÃæ¡¢Ô´´úÂëÊÜÏà¹Ø·¨Âɱ£»¤£¬Î´¾­ÊÚȨ£¬ÑϽûʹÓÃ
×ÉѯÈÈÏߣº40000 85735  ÓÊÏ䣺web@qidian.biz  µØÖ·£ºÉϺ£ÊÐ»ÆÆÖÇøÕã½­Öз398-400ºÅ´ºÉê½­´óÏÃ1007ÊÒ
ÉϺ£ÍøÕ¾½¨ÉèÍÆ¹ãר¼ÒÆæµäÍøÂçÊÇÍøÂç»ù´¡·þÎñ·þÎñÉÌÓëÆ·ÅÆ×ÊÔ´ÕûºÏר¼Ò-ÉϺ£ÆæµäÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾,ÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú¡¢ÍøÕ¾½¨Éè¡¢½¨Õ¾±¦ºÐ¡¢ÓòÃû¿Õ¼äµÈ»¥ÁªÍøÓ¦Ó÷þÎñ¡£   
Copyright © 2010-2019 www.qidian.biz All rights reserved £ü 
¿Í·þ΢ÐÅ
ɨÂëÁªÏµ¿Í·þ
ÒÔÏÂjsΪ²âÊÔÐÅÏ¢