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

SQL Server·þÎñÆ÷½ÇÉ«ÓëÊý¾Ý¿â½ÇÉ«Çø±ð

¹Ì¶¨·þÎñÆ÷½ÇÉ«
sysadmin ¿ÉÒÔÔÚ SQL Server ÖÐÖ´ÐÐÈκλ¡£
serveradmin ¿ÉÒÔÉèÖ÷þÎñÆ÷·¶Î§µÄÅäÖÃÑ¡Ï¹Ø±Õ·þÎñÆ÷¡£
setupadmin ¿ÉÒÔ¹ÜÀíÁ´½Ó·þÎñÆ÷ºÍÆô¶¯¹ý³Ì¡£
securityadmin ¿ÉÒÔ¹ÜÀíµÇ¼ºÍ CREATE DATABASE ȨÏÞ£¬»¹¿ÉÒÔ¶ÁÈ¡´íÎóÈÕÖ¾ºÍ¸ü¸ÄÃÜÂë¡£
processadmin ¿ÉÒÔ¹ÜÀíÔÚ SQL Server ÖÐÔËÐеĽø³Ì¡£
dbcreator ¿ÉÒÔ´´½¨¡¢¸ü¸ÄºÍ³ýÈ¥Êý¾Ý¿â¡£
diskadmin ¿ÉÒÔ¹ÜÀí´ÅÅÌÎļþ¡£
bulkadmin ¿ÉÒÔÖ´ÐÐ BULK INSERT Óï¾ä¡£
·þÎñÆ÷½ÇÉ«ÊÇÕë¶Ô·þÎñÆ÷Õâ¸ö²ã´ÎµÄȨÏÞ¶øÑÔµÄ,Ò²¾ÍÊÇ˵һ°ã¼ÓÈëµ½·þÎñÆ÷½ÇÉ«ÀïµÄÓû§¶¼ÊǾßÓжԷþÎñÆ÷Ò»¶¨µÄ¹ÜÀíȨÏÞ
Êý¾Ý¿â½ÇÉ«
db_owner ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÖ´ÐÐÊý¾Ý¿âµÄËùÓÐÅäÖúÍά»¤»î¶¯£¬»¹¿ÉÒÔɾ³ýÊý¾Ý¿â¡£
db_securityadmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÐ޸ĽÇÉ«³ÉÔ±Éí·ÝºÍ¹ÜÀíȨÏÞ¡£Ïò´Ë½ÇÉ«ÖÐÌí¼ÓÖ÷Ìå¿ÉÄܻᵼÖÂÒâÍâµÄȨÏÞÉý¼¶¡£
db_accessadmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔΪ Windows µÇ¼Ãû¡¢Windows ×éºÍ SQL Server µÇ¼ÃûÌí¼Ó»òɾ³ýÊý¾Ý¿â·ÃÎÊȨÏÞ¡£
db_backupoperator ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ±¸·ÝÊý¾Ý¿â¡£
db_ddladmin ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔÚÊý¾Ý¿âÖÐÔËÐÐÈκÎÊý¾Ý¶¨ÒåÓïÑÔ (DDL) ÃüÁî¡£
db_datawriter ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔÔÚËùÓÐÓû§±íÖÐÌí¼Ó¡¢É¾³ý»ò¸ü¸ÄÊý¾Ý¡£
db_datareader ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±¿ÉÒÔ´ÓËùÓÐÓû§±íÖжÁÈ¡ËùÓÐÊý¾Ý¡£
db_denydatawriter ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±²»ÄÜÌí¼Ó¡¢Ð޸Ļòɾ³ýÊý¾Ý¿âÄÚÓû§±íÖеÄÈκÎÊý¾Ý¡£
db_denydatareader ¹Ì¶¨Êý¾Ý¿â½ÇÉ«µÄ³ÉÔ±²»ÄܶÁÈ¡Êý¾Ý¿âÄÚÓû§±íÖеÄÈκÎÊý¾Ý¡£
Êý¾Ý¿â½ÇÉ«ÊÇÕë¶ÔÊý¾Ý¿â²ã´Î¶øÑԵģ¬Óû§¼ÓÈ뵽ij¸öÊý¾Ý¿âµÄÊý¾Ý¿â½ÇÉ«Öкó,Õâ¸öÓû§Ö»ÊÇÔÚÕâ¸öÊý¾Ý¿âÀïÃæ¾ßÓÐÔÚ½ÇÉ«ÀïÖ¸¶¨µÄÓû§È¨ÏÞ¡£
Ò»¸öÓû§µÄ×îÖÕȨÏÞÊÇÓÉ ·þÎñÆ÷½ÇÉ«ÓëÊý¾Ý¿â½ÇÉ«×é³ÉµÄ


Ïà¹ØÎĵµ£º

SQLÓï¾ä

ǰ¶Îʱ¼äѧµÄÓйØsqlµÄÏà¹ØÖªÊ¶,ºÜ¶à¶¼Ã»¼°Ê±È¥ÕûÀí,½ñÌì¸ÕºÃÓÐʱ¼äÓÐûÐÄÇé×öÆäËûµÄÊÇ,¾ÍÕûÀíÕûÀí°É
      Ò»Ö±ÒÔΪ×ö¿ª·¢µÄ¶ÔÊý¾Ý¿â²Ù×÷·½ÃæµÄÒªÇó²»»áºÜ¸ß,Ö»Òª»á¶ÔÊý¾ÝÔöɾ¸Ä²é¾ÍokÁË.ÏÖÔÚ²ÅÖªµÀ¶ÔÊý¾Ý¿âµÄ²Ù×÷»¹Ó¦¸Ã°üÀ¨Ð´´æ´¢ºÍº¯Êý,»¹Òª´´½¨ÐòÁС¢Ë÷Òý,ÊÓͼµÈ.
     ......

SQL SERVER 2008 R2ÐÂÌØÐÔ

      ¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼­´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server.

Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäËü° ......

sql server2005 rownumͨÓô洢¹ý³Ì·ÖÒ³

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER   PROCEDURE [dbo].[sp_GetRecordfromPage]
@TableName varchar(350),        --±íÃû
@Fields varchar(5000) = '*',    --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
@OrderField varchar(5000),   &nbs ......

SQL SERVERÊý¾ÝÀàÐÍÓëC#Êý¾ÝÀàÐͶÔÕÕ±í

bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ Int64
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£ Int32
smallint ´Ó -2^15 (-32,768) µ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ