¶¯Ì¬´´½¨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
ÃÜÂëÒѾ¹ý¹þÏ£ÔËËã
Ïà¹ØÎĵµ£º
1¡¢ÅäÖÃjava»·¾³£¬MyEclipse7.0¡£ÅäÖÃjboss5.0£¬Õ¹¿ªÑ¡ÔñjdkΪÒѰ²×°µÄjdk·¾¶¡£
2¡¢°²×°2005ºÍsql2000£¬×°2000ʱҪװsp4.Çý¶¯Ñ¡Ôñjdbc2.0¡£ÔÙ×°2000ʱʵÀýÃû×Ô¼ºÊäÈëÒ»¸ö¡£ÕâÀïµÄÎÊÌâ¾ÍÊǵǼÃûºÍÃÜÂëµÄÉèÖã¬ÓÒ»÷“SQL Server×é”ϵÄʵÀýÃû£¨Windows NT)"µÄ“ÊôÐÔ”£¬ÔÚµ¯³öµÄ¶Ô»°¿ò ......
ÏÖÔÚ´ó¶àÊýÃèÊöSQL Server 2005ÐÂÌØÐÔµÄÎÄÕ¶¼¹Ø×¢ÓÚ»ª¶ø²»ÊµµÄÌØÐÔ£¬ÈçSQLCLR»òXMLÊý¾ÝÀàÐÍ£¬¶ø¶ÔÐí¶àºÜºÃµÄÀϵÄT-SQLÓïÑԵĸĽøÃ»Óеõ½Ó¦ÓеĹØ×¢¡£ÎÒÔø¾´ÓÐí¶àDBA¿ÚÖÐÌýµ½ÁîËûÃǸüÐ˷ܵÄÊÇ¿´µ½T-SQLÓïÑԵĸĽø,¶ø²»ÊÇÄÇЩгöÏֺͷ¢²¼µÄ¹¦ÄÜ¡£¶ÔÓÚSQLÓïÑÔµÄÒ»¸öºÜÓÐÓõÄʵ¼Ê¸Ä½øÊÇOUTPUT×Ӿ䣬ËüÔÊÐí²éѯһ¸öÊý¾ ......
ÕýÔÚ¼ÓÔØÊý¾Ý...
¡¡¡¡1.°´ÐÕÊϱʻÅÅÐò: select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
¡¡¡¡2.Êý¾Ý¿â¼ÓÃÜ: select encrypt(’ÔʼÃÜÂë’) select pwdencrypt(’ÔʼÃÜÂë’) select pwdcompare(’ÔʼÃÜÂë’,’¼ÓÃܺóÃÜÂë’) = 1--Ïàͬ£»·ñÔ ......
SQL Server 2005Òý½øÁËÒ»¸öºÜÓмÛÖµµÄеÄTransact-SQLÓïÑÔ×é¼þ£ºÒ»¸öͨÓñí±í´ïʽ£¨Common Table Expression£¬CTE£©£¬ËüÊÇÅÉÉú±íºÍÊÓͼµÄÒ»¸ö±ã½ÝµÄÌæ´ú¡£Í¨¹ýʹÓÃCTE£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ò»¸öÃüÃû½á¹û¼¯À´ÔÚSELECT¡¢INSERT¡¢UPDATEºÍDELETEÓï¾äÖÐÒýÓ㬶øÎÞÐë±£´æ½á¹û¼¯½á¹¹µÄÈκÎÔªÊý¾Ý¡£ÔÚ±¾ÎÄÖУ¬ÎÒ½«²ûÊöÈçºÎÔÚSQL Server 2 ......