Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL SERVER ½Çɫ˵Ã÷£¨Õª×ÔMSDN£©


·þÎñÆ÷¼¶±ð½ÇÉ«
Ϊ±ãÓÚ¹ÜÀí·þÎñÆ÷ÉϵÄȨÏÞ£¬SQL Server ÌṩÁËÈô¸É“½ÇÉ«”£¬ÕâЩ½ÇÉ«ÊÇÓÃÓÚ·Ö×éÆäËûÖ÷ÌåµÄ°²È«Ö÷Ìå¡£“½ÇÉ«”ÀàËÆÓÚ Microsoft Windows ²Ù×÷ϵͳÖеē×锡£
·þÎñÆ÷¼¶½ÇɫҲ³ÆÎª“¹Ì¶¨·þÎñÆ÷½ÇÉ«”£¬ÒòΪÄú²»ÄÜ´´½¨ÐµķþÎñÆ÷¼¶½ÇÉ«¡£·þÎñÆ÷¼¶½ÇÉ«µÄȨÏÞ×÷ÓÃÓòΪ·þÎñÆ÷·¶Î§¡£
Äú¿ÉÒÔÏò·þÎñÆ÷¼¶½ÇÉ«ÖÐÌí¼Ó SQL Server µÇ¼Ãû¡¢Windows ÕÊ»§ºÍ Windows ×é¡£¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄÿ¸ö³ÉÔ±¶¼¿ÉÒÔÏòÆäËùÊô½ÇÉ«Ìí¼ÓÆäËûµÇ¼Ãû¡£
ϱíÏÔʾÁË·þÎñÆ÷¼¶½ÇÉ«¼°ÆäÄܹ»Ö´ÐеIJÙ×÷¡£
·þÎñÆ÷¼¶½ÇÉ«Ãû³ÆËµÃ÷
sysadmin
sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔÚ·þÎñÆ÷ÉÏÖ´ÐÐÈκλ¡£
serveradmin
serveradmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ¸ü¸Ä·þÎñÆ÷·¶Î§µÄÅäÖÃÑ¡ÏîºÍ¹Ø±Õ·þÎñÆ÷¡£
securityadmin
securityadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ¹ÜÀíµÇ¼Ãû¼°ÆäÊôÐÔ¡£ËûÃÇ¿ÉÒÔ GRANT¡¢DENY ºÍ REVOKE ·þÎñÆ÷¼¶±ðµÄȨÏÞ¡£ËûÃÇ»¹¿ÉÒÔ GRANT¡¢DENY ºÍ REVOKE Êý¾Ý¿â¼¶±ðµÄȨÏÞ¡£´ËÍ⣬ËûÃÇ»¹¿ÉÒÔÖØÖà SQL Server µÇ¼ÃûµÄÃÜÂë¡£
processadmin
processadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÖÕÖ¹ÔÚ SQL Server ʵÀýÖÐÔËÐеĽø³Ì¡£
setupadmin
setupadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÌí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷¡£
bulkadmin
bulkadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔËÐÐ BULK INSERT Óï¾ä¡£
diskadmin
diskadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«ÓÃÓÚ¹ÜÀí´ÅÅÌÎļþ¡£
dbcreator
dbcreator ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ´´½¨¡¢¸ü¸Ä¡¢É¾³ýºÍ»¹Ô­ÈκÎÊý¾Ý¿â¡£
public
ÿ¸ö SQL Server µÇ¼Ãû¶¼ÊôÓÚ public ·þÎñÆ÷½ÇÉ«¡£Èç¹ûδÏòij¸ö·þÎñÆ÷Ö÷ÌåÊÚÓè»ò¾Ü¾ø¶Ôij¸ö°²È«¶ÔÏóµÄÌØ¶¨È¨ÏÞ£¬¸ÃÓû§½«¼Ì³ÐÊÚÓè¸Ã¶ÔÏóµÄ public ½ÇÉ«µÄȨÏÞ¡£Ö»ÓÐÔÚÏ£ÍûËùÓÐÓû§¶¼ÄÜʹÓöÔÏóʱ£¬²ÅÔÚ¶ÔÏóÉÏ·ÖÅä Public ȨÏÞ¡£
ÓйطþÎñÆ÷¼¶±ð½ÇɫȨÏÞµÄÌØ¶¨ÐÅÏ¢£¬Çë²ÎÔĹ̶¨·þÎñÆ÷½ÇÉ«µÄȨÏÞ£¨Êý¾Ý¿âÒýÇæ£©¡£
Êý¾Ý¿â¼¶±ðµÄ½ÇÉ«
Ϊ±ãÓÚ¹ÜÀíÊý¾Ý¿âÖеÄȨÏÞ£¬SQL Server ÌṩÁËÈô¸É“½ÇÉ«”£¬ÕâЩ½ÇÉ«ÊÇÓÃÓÚ·Ö×éÆäËûÖ÷ÌåµÄ°²È«Ö÷Ìå¡£ËüÃÇÀàËÆÓÚ Microsoft Windows ²Ù×÷ϵͳÖеÄ×é¡£Êý¾Ý¿â¼¶½ÇÉ«µÄȨÏÞ×÷ÓÃÓòΪÊý¾Ý¿â·¶Î§¡£
SQL Server ÖÐÓÐÁ½ÖÖÀàÐ͵ÄÊý¾Ý¿â¼¶½ÇÉ«£ºÊý¾Ý¿âÖÐÔ¤¶¨ÒåµÄ“¹Ì¶¨Êý¾Ý¿â½ÇÉ«”ºÍÄú¿ÉÒÔ´´½¨µÄ“Áé»îÊý¾Ý¿â½ÇÉ«”¡£
¹Ì¶¨Êý¾Ý¿â½ÇÉ«ÊÇÔÚÊý¾Ý¿â¼¶±ð¶¨ÒåµÄ£¬²¢ÇÒ´æÔÚÓÚÿ¸öÊý¾Ý¿âÖС£db_owner ºÍ db_securityadmin&nb


Ïà¹ØÎĵµ£º

SQL Server ÃæÊÔÌâ

Sql³£¼ûÃæÊÔÌ⣨×ܽᣩ
0.ÈçºÎɾ³ýÒ»¸öÓµÓбȽ϶àµÄÊý¾ÝµÄ±í
Èç¹û¸Ã±íËùÔÚµÄÊý¾Ý¿âÓµÓнÏÉÙµÄ±í£¬¿ÉÒÔÏȽ«ÆäÓà±íµ¼³öÈ¥£¬È»ºó·ÖÀëÊý¾Ý¿â£¬ÔÚɾ³ý£¬Ð½¨Ò»¸öͬÃûÊý¾Ý¿â£¬½«ÆäÓà±íÔٴε¼Èë¡£
1.ÓÃÒ»ÌõSQLÓï¾ä ²éѯ³öÿÃſζ¼´óÓÚ80·ÖµÄѧÉúÐÕÃû  
name kecheng fenshu
ÕÅÈý     ÓïÎÄ  &n ......

ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨

ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
    ÎªÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
    ¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u r ......

oracleÖÐsql loaderµÄÓ÷¨

sql loader ¹¤¾ßËü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾ÝÓеãÂé·³¡£
ÔÚDOCÏÂÃæÊäÈ룺sqlldr userid=user/password@sid control=result.ctl
Àý×Ó:
SQLLDR USERID=zero/zero@ORACLE CONTROL ......

SQLʱ¼äÀàÐÍÄ£ºý²éѯ

     Êý¾Ý¿âÀàÐÍΪDateTimeÀàÐÍ£¬½«Æä×öÄ£ºý²éѯʱ£¬ÔÚHibernateÖУ¬¿ÉÒÔÓÃÆ´SQLµÄÎÊÌ⽫Æä½â¾ö£¬¼´ÔÚSQL²éѯ·ÖÎöÆ÷дSQLÒ»Ñù£¬µ«ÊÇÀûÓòÎÊýÅäÖã¬Ôò·½·¨ÈçÏ£º
     1¡¢Æ´ÉÏSQL,È磺
            String beginPara= &q ......

[SQL 2000]·¢Éú´íÎó1069£ºÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯·þÎñ

ͬʱÆô¶¯ÆäËûsql ·þÎñ»á³öÏÖ ´íÎó1068:ÒÀ´æ·þÎñ»ò×éÎÞ·¨Æô¶¯£¨ÕâÊÇÓÉÓÚ¼¸¸öÏà¹ØÁªµÄ·þÎñÖÐÓÐÒ»¸ö²»ÄÜÆô¶¯£©¡£
´íÎó1069ÊÇÒ»¸öWindows NT/2000µÄϵͳ´íÎó¡£´íÎó1069±íÃ÷·þÎñ²»Äܱ»Æô¶¯£¨µ±Æô¶¯·þÎñʱ·µ»Ø“µÇ¼ʧ°Ü”´íÎ󣩡£ÀýÈ磬µ±Æô¶¯MSSQLServer·þÎñʱ£¬µÃµ½ÈçÏ´íÎóÌáʾ£º
·¢Éú´íÎó1069£ºÓÉÓڵǼʧ° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ