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

SQL SERVER ´¦Àí¹ÂÁ¢ÕÊ»§

¹ÂÁ¢ÕÊ»§£¬¾ÍÊÇij¸öÊý¾Ý¿âµÄÕÊ»§Ö»ÓÐÓû§Ãû¶øÃ»ÓеǼÃû£¬ÕâÑùµÄÓû§ÔÚÓû§¿âµÄsysusersϵͳ±íÖдæÔÚ£¬¶øÔÚmasterÊý¾Ý¿âµÄsysloginsÖÐȴûÓжÔÓ¦µÄ¼Ç¼¡£
¹ÂÁ¢ÕÊ»§µÄ²úÉúÒ»°ãÊÇÒÔÏÂÁ½ÖÖ£º
1.½«±¸·ÝµÄÊý¾Ý¿âÔÚÆäËü»úÆ÷ÉÏ»¹Ô­£»
2.ÖØ×°ÏµÍ³»òSQL SERVERÖ®ºóÖ»»¹Ô­ÁËÓû§¿â
½â¾ö·½·¨ÊÇʹÓÃsp_change_users_loginÀ´ÐÞ¸´¡£
sp_change_users_loginµÄÓ÷¨ÓÐÈýÖÖ
Ó÷¨1£º
exec sp_change_users_login 'REPORT'
Áгöµ±Ç°Êý¾Ý¿âµÄ¹ÂÁ¢Óû§
Ó÷¨2£º
exec sp_change_users_login 'AUTO_FIX','Óû§Ãû'
¿ÉÒÔ×Ô¶¯½«Óû§ÃûËù¶ÔÓ¦µÄͬÃûµÇ¼Ìí¼Óµ½sysloginsÖÐ
Èç¹ûûÓн¨Á¢testuserµÄµÇ¼Óû§£¬»¹¿ÉÒÔÓÃ
sp_change_users_login 'Auto_Fix', 'testuser', NULL, 'testpass'
Ó÷¨3£º
exec sp_change_users_login 'UPDATE_ONE','Óû§Ãû','µÇ¼Ãû'
½«Óû§ÃûÓ³ÉäΪָ¶¨µÄµÇ¼Ãû¡£


Ïà¹ØÎĵµ£º

Microsoft SQL Server ¹ÜÀí £¨³£ÓùÜÀí¼°Î¬»¤ÃüÁ


--²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername
--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate
--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb
--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
sel ......

½ÓÉÏһƪÎÄÕ£¬µ¼³öÒ»¸ö±í£¬»òÕßÕû¸öÊý¾Ý¿âµ½SQLÐÎʽ

 <?php
 require_once '../../smartyConfig/smartyConfig.class.php';
 require_once '../../game/include/function.php';
 require_once '../../game/include/config.php';
 require_once '../../game/server/server.class.php';
 require_once '../../game/include/db.class.php'; ......

sql ³£ÓþۺϺ¯Êý

8.2  ¾ÛºÏº¯ÊýµÄÓ¦ÓÃ
¾ÛºÏº¯ÊýÔÚÊý¾Ý¿âÊý¾ÝµÄ²éѯ·ÖÎöÖУ¬Ó¦ÓÃÊ®·Ö¹ã·º¡£±¾½Ú½«·Ö±ð¶Ô¸÷¾ÛºÏº¯ÊýµÄÓ¦ÓýøÐÐ˵Ã÷¡£
8.2.1  ÇóºÍº¯Êý——SUM()
ÇóºÍº¯ÊýSUM( )ÓÃÓÚ¶ÔÊý¾ÝÇóºÍ£¬·µ»ØÑ¡È¡½á¹û¼¯ÖÐËùÓÐÖµµÄ×ܺ͡£Óï·¨ÈçÏ¡£
SELECT          SUM(column_name) ......

SQL¹ÂÁ¢Óû§½â¾ö·½°¸

 ¡¡  Ö¢×´
¡¡¡¡µ±Äú½«Êý¾Ý¿â±¸·Ý»Ö¸´µ½Áíһ̨·þÎñÆ÷ʱ£¬¿ÉÄÜ»áÓöµ½¹ÂÁ¢Óû§µÄÎÊÌâ¡£SQL Server Áª»ú´ÔÊéÖеĹÂÁ¢Óû§ÒÉÄѽâ´ðÖ÷ÌâÖÐûÓн²Êö½â¾ö´ËÎÊÌâµÄ¾ßÌå²½Öè¡£
¡¡¡¡±¾ÎĽéÉÜÁËÈçºÎ½â¾ö¹ÂÁ¢Óû§ÎÊÌâ¡£
¡¡¡¡×´Ì¬
¡¡¡¡Microsoft ÒѾ­È·ÈÏÕâÊÇÔÚ±¾ÎÄ¿ªÍ·ÁгöµÄ Microsoft ²úÆ·ÖдæÔÚµÄÎÊÌâ¡£
¡¡¡¡¸ü¶àÐÅÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ