¶¯Ì¬´´½¨Sql ServerÓû§¼°ÆäȨÏÞ
Ò»¡¢ÈçºÎ¶¯Ì¬´´½¨Óû§
1.ʹÓô洢¹ý³Ì
sp_addlogin (Transact-SQL)
´´½¨Ð嵀 SQL Server µÇ¼£¬¸ÃµÇ¼ÔÊÐíÓû§Ê¹Óà SQL Server Éí·ÝÑéÖ¤Á¬½Óµ½ SQL Server ʵÀý¡£
ÖØÒªÌáʾ£º
ºóÐø°æ±¾µÄ Microsoft SQL Server ½«É¾³ý¸Ã¹¦ÄÜ¡£Çë±ÜÃâÔÚеĿª·¢¹¤×÷ÖÐʹÓøù¦ÄÜ£¬²¢×ÅÊÖÐ޸ĵ±Ç°»¹ÔÚʹÓøù¦ÄܵÄÓ¦ÓóÌÐò¡£Çë¸ÄÓà CREATE LOGIN¡£
°²È«ËµÃ÷£º
Ç뾡¿ÉÄÜʹÓà Windows Éí·ÝÑéÖ¤¡£
Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
sp_addlogin [ @loginame = ] 'login'
[ , [ @passwd = ] 'password' ]
[ , [ @defdb = ] 'database' ]
[ , [ @deflanguage = ] 'language' ]
[ , [ @sid = ] sid ]
[ , [ @encryptopt= ] 'encryption_option' ]
²ÎÊý
[ @loginame = ] 'login'
µÇ¼µÄÃû³Æ¡£login µÄÊý¾ÝÀàÐÍΪ sysname£¬ÎÞĬÈÏÖµ¡£
[ @passwd = ] 'password'
µÇ¼µÄÃÜÂë¡£password µÄÊý¾ÝÀàÐÍΪ sysname£¬Ä¬ÈÏֵΪ NULL¡£
°²È«ËµÃ÷£º
²»ÒªÊ¹ÓÿÕÃÜÂë¡£ÇëʹÓÃÇ¿ÃÜÂë¡£
[ @defdb = ] 'database'
µÇ¼µÄĬÈÏÊý¾Ý¿â£¨ÔڵǼºóµÇ¼Ê×ÏÈÁ¬½Óµ½¸ÃÊý¾Ý¿â£©¡£database µÄÊý¾ÝÀàÐÍΪ sysname£¬Ä¬ÈÏֵΪ master¡£
[ @deflanguage = ] 'language'
µÇ¼µÄĬÈÏÓïÑÔ¡£language µÄÊý¾ÝÀàÐÍΪ sysname£¬Ä¬ÈÏֵΪ NULL¡£Èç¹ûδָ¶¨ language£¬ÔòеǼµÄĬÈÏ language ½«ÉèÖÃΪ·þÎñÆ÷µÄµ±Ç°Ä¬ÈÏÓïÑÔ¡£
[ @sid = ] 'sid'
°²È«±êʶºÅ (SID)¡£sid µÄÊý¾ÝÀàÐÍΪ varbinary(16)£¬Ä¬ÈÏֵΪ NULL¡£Èç¹û sid Ϊ NULL£¬Ôòϵͳ½«ÎªÐµÇ¼Éú³É SID¡£²»¹ÜÊÇ·ñʹÓà varbinary Êý¾ÝÀàÐÍ£¬NULL ÒÔÍâµÄÖµµÄ³¤¶È¶¼±ØÐëÕýºÃÊÇ 16 ¸ö×Ö½Ú£¬²¢ÇÒÒ»¶¨²»ÄÜÒѾ´æÔÚ¡£Ö¸¶¨ sid ·Ç³£ÓÐÓã¬ÀýÈ磬Èç¹ûÄúÒª±àд½Å±¾£¬»ò½« SQL Server µÇ¼´Óһ̨·þÎñÆ÷ÒÆ¶¯µ½Áíһ̨·þÎñÆ÷£¬²¢ÇÒÏëÈõǼÔÚ²»Í¬·þÎñÆ÷ÉÏʹÓÃÏàͬµÄ SID£¬¶¼ÐèÒªÖ¸¶¨Ëü¡£
[ @encryptopt = ] 'encryption_option'
Ö¸¶¨ÊÇÒÔÃ÷ÎÄÐÎʽ£¬»¹ÊÇÒÔÃ÷ÎÄÃÜÂëµÄ¹þÏ£ÔËËã½á¹ûÀ´´«µÝÃÜÂë¡£×¢Ò⣬²»½øÐмÓÃÜ¡£ÔÚ±¾ÌÖÂÛÖÐʹÓÓ¼ÓÃܔһ´ÊÊÇΪÁËÏòºó¼æÈÝ¡£Èç¹û´«ÈëÃ÷ÎÄÃÜÂ룬½«¶ÔËü½øÐйþÏ£ÔËËã¡£¹þÏ£Öµ½«´æ´¢ÆðÀ´¡£encryption_option µÄÊý¾ÝÀàÐÍΪ varchar(20)£¬¿ÉÒÔÊÇÏÂÁÐÖµÖ®Ò»£º
Öµ ˵Ã÷
NULL
ÒÔÃ÷ÎÄÐÎʽ´«µÝÃÜÂë¡£ÕâÊÇĬÈÏÉèÖá£
skip_encryption
ÃÜÂëÒѾ¹ý¹þÏ£ÔËËã
Ïà¹ØÎĵµ£º
ʹÓÃÕûÊýÊý¾ÝµÄ¾«È·Êý×ÖÊý¾ÝÀàÐÍ¡£
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£
´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,64 ......
[C#]
public void RunSqlTransaction(string myConnString)
{
SqlConnection myConnection = new SqlConnection(myConnString);
myConnection.Open();
SqlCommand myCommand = myConnection.CreateCommand();
SqlTransaction m ......
1. Sql ÑÓʱºòÖ´ÐÐ
a. ÈýÊ®ÃëºóÖ´ÐÐ WAITFOR DELAY ºóÃæµÄÓï¾ä
WAITFOR DELAY '00:00:30'
b. 10:00·Ö¿ªÊ¼Ö´ÐкóÃæµÄ´úÂë
WAITFOR TIME '10:00';
2. ÊÕËõÊý¾Ý¿â£¬Ê¹Æä¿ÕÓà¿Õ¼äΪ0%
DBCC SHRINKDATABASE (DataBaseName,0)
3. È¡µÃÊý¾Ý¿âÎļþËùÔÚµÄÅÌ·û
declare @dirverNam ......
ÕâÁ½Ììдһ¸öºÍͳ¼ÆÊý¾ÝÓйصĴ洢¹ý³Ì£¬ÀïÃæÒªÀûÓÃÈÕÆÚ½øÐÐһЩ¼ÆËãºÍÅжϣ¬Ò²×ÔȻҪÀûÓÃSQLµÄһЩÈÕÆÚÏà¹ØµÄº¯Êý¡£ÕâÀïÂÔ¼Çһϣ¬µ±ÊǸ´Ï°Ò»ÏÂSQL¡£
ÀûÓÃSQL½Å±¾ÄÚÖõöº¯Êý£¬ÎÒÃÇÄÜÁé»îµÄ¶ÔÈÕÆÚ½øÐмÆËãºÍ±È½Ï¡£³£Óõöº¯Êý£ºGETDATE(),DATEDIFF(),DATEADD()
GETDATE() µ±È»¹ËÃû˼Ò壬µÃµ½µ±Ç°µÄÈÕÆÚ£¬·µ»ØÀàÐÍÊ ......
ÔÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“° ......