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¡£
Óô´½¨¸Ã¶ÔÏóµÄÓû§ÃûÏÞ¶¨¡£
Ïà¹ØÎĵµ£º
Á¬½ÓAccess
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëƬ¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwind.mdb" ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
orACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ ......
ÔÚSQL ServerÀィMysqlºÍOracleÊý¾Ý¿âÁ´½Ó»¹ÊDZȽÏÈÝÒ׵ģºÎÒÃÇÏÈÔÚ·þÎñÆ÷ÉÏ°²×°MysqlºÍOracleÊý¾Ý¿âÏà¹ØµÄODBCÇý¶¯³ÌÐò£¬ÔÚ[¹ÜÀí¹¤¾ß]->[Êý¾ÝÔ´(ODBC)] ÉèÖÃϵͳDSN£¬ÈçÏÂͼ:
ÉèÖúÃÁËÒÔºó£¬ÎÒÃÇ¿ÉÒÔÓÃSQL Server×Ô´øµÄµ¼³öºÍµ¼È빤¾ßÀ´Êµ ......
RowidµÄ¸ÅÄ
rowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬ÔòrowidÔÚ¸ÃÐеÄÉúÃüÖÜÆÚÄÚÊÇΨһµÄ£¬¼´ ......
Ö´Ðмƻ®µÄ²½Öè
Ö´Ðмƻ®µÄÿһ²½·µ»ØÒ»×éÐУ¬ËüÃÇ»òÕßΪÏÂÒ»²½ËùʹÓ㬻òÕßÔÚ×îºóÒ»²½Ê±·µ»Ø¸ø·¢³öSQLÓï¾äµÄÓû§»òÓ¦Óá£ÓÉÿһ²½·µ»ØµÄÒ»×éÐнÐ×öÐÐÔ´(row source£©¡£Í¼5-1Ê÷״ͼÏÔʾÁË´ÓÒ»²½µ½ÁíÒ»²½ÐÐÊý¾ÝµÄÁ÷¶¯Çé¿ö¡£Ã¿²½µÄ±àºÅ·´Ó³ÁËÔÚÄã¹Û²ìÖ´Ðмƻ®Ê±Ëùʾ²½ÖèµÄ˳Ðò£¨ÈçºÎ¹Û²ìÖ´Ðмƻ®½«±»¼ò¶ÌµØ˵Ã÷£©¡£Ò»°ãÀ´ ......