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
Ïà¹ØÎĵµ£º
ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHA ......
ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
ΪÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u r ......
²Î¿¼¡¶ASP.NETÓëSQLÒ»Æð´ò°ü²¿Êð°²×°¡·£¬ÕâÆªÎÄÕÂÊÇÕë¶ÔVB.NETÓëSQL Ò»Æð´ò°üµÄ,µ«ÊÇÎÒʹÓõÄÊÇC#,µ±È»Ö»ÒªÐÞ¸ÄÒ»ÏÂÖ÷Òª°²×°Àà¿â¾ÍÐÐÁË!C#µÄÀà¿â´úÂëÈçÏÂ:DBCustomAction.cs
using System;
using System.Collections;
using System.Data.SqlClient;
using System.ComponentModel;
using System.Configuration.Install; ......
Ò»¡¢²Ù×÷·ûÓÅ»¯
1¡¢IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓOracleÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³É¹ ......