²ÉÓÃvs2005¶Ôsqlserver 2005 SP½øÐе¥²½µ÷ÊÔ
ms sqlserver 2005ÖеĴ洢¹ý³ÌÎÞ·¨ÔÚManagement StudioÖнøÐе÷ÊÔ£¬
µ«¿ÉÒÔͨ¹ýVisual Studio 2005À´¶ÔÖ®½øÐе÷ÊÔ¡££¨¿ÉÉèÖöϵ㣬µ¥²½µ÷ÊԵȣ©
²ÉÓÃVisual Studioµ÷ÊÔ´æ´¢¹ý³ÌµÄ·½·¨ÈçÏ£º
1.Æô¶¯Visual Studio£¨¿É²»´´½¨ÏîÄ¿£©£¬´ò¿ªServer Explorer£¨²Ëµ¥£view-Server Explorer)
2.ÔÚServer ExplorerÖд´½¨Ò»¸öµ½º¬ÓÐÐèµ÷ÊÔµÄÊý¾Ý¿âµÄÁ¬½Ó£¬£¨±ØÐëÌṩ·þÎñÆ÷ÃûÒÔ¼°µÇ¼ÑéÖ¤£©¡£
3.Á¬½Óºó£¬Õ¹¿ª´ËÊý¾Ý¿âµÄÊ÷Ðνṹ£¬²¢Õ¹¿ª´æ´¢¹ý³ÌÎļþ¼Ð£¬ÓÒ»÷Ðèµ÷ÊԵĴ洢¹ý³Ì£¬²¢ÔÚÓÒ¼ü²Ëµ¥ÖÐÑ¡Ôñ“µ¥²½µ÷ÊÔ´æ´¢¹ý³Ì”¼´¿ÉÆô¶¯µ÷ÊÔÁË¡££¨µ÷ÊԵķ½·¨Í¬Visual Studio,¼´Ö§³Ö¶Ïµã£¬µ¥²½µ÷ÊԵȣ©
Ïà¹ØÎĵµ£º
ÈçºÎÔÚSqlserverÖдÓÍⲿXMLÎļþÖжÁÈ¡ÅäÖÃÐÅÏ¢ÄØ£¿¸ÃÎÊÌâÔ´×ÔÒ»¼ÒÆóÒµµÄ±ÊÊÔÐÅÏ¢ÓиС£
Ò»xmlÎļþÄÚÈÝ£º
<?xml version="1.0" encoding="utf-8"?>
<root>
<db name="ClientDB1" datasize="512MB" datagrowth="100MB" logsize="100MB" loggrowth ="50MB">
</db>
<db ......
×Ö·û´®º¯Êý£º
¡ñ¡¡ASCII('a')=97---·µ»Ø×Öĸa¶ÔÓ¦µÄASCIIÂë
¡ñ¡¡CHAR('48')=0---·µ»Ø48Õâ¸öASCIIÂë¶ÔÓ¦µÄ×Ö·û
¡ñ¡¡LCASE('ABcdE')="abced" »ò LOWER('ABcdE')="abced"£¨½«¸ø¶¨×Ö·û´®×ªÎªÐ¡Ð´£©
¡ñ¡¡UCASE('ABcdE')="ABCDE" »ò UPPER('ABcdE')="ABCDE"£¨½«¸ø¶¨×Ö·û´®×ªÎª´óд£©
¡ñ¡¡LTRIM(' fgf gh ')="fgf ......
/******************************
ϵͳº¯Êý
******************************/
--convert ÓÃÀ´×ª±äÊý¾ÝÀàÐÍ
--convert (data_type[(length)], expression [, style])
select convert(int,convert(varchar(5),12345)+'678')+1 --·µ»Ø12345679
--cast Ò²ÊÇÓÃÀ´×ª»»Êý¾ÝÀàÐÍ
--cast(expression as data_type[(l ......
Ë÷ÒýµÄÖØÒªÐÔ
Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¾Û´ØË÷Òý
(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý
(Non- Clustered Index)
×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·µ½Ð»ª×ÖµäµÄº ......
²é¿´ÊÇ·ñÇø·Ö´óСд-Ö´Ðд洢¹ý³Ìsys.sp_server_info
exec sys.sp_server_info
²é¿´µÚ18ÐÐCOLLATION_SEQ-collationÊôÐÔ
charset=cp936 collation=Chinese_PRC_CS_AS
csÎªÇø·Ö´óСд£¬CIΪ²»Çø·Ö´óСд
½«Çø·Ö´óСд¸ÄΪ²»Çø·Ö´óСд
alter database yourDB COLLATE Chinese_PRC_CI_AS
½«²»Çø·Ö´óСд¸ÄÎªÇø·Ö´óСд
......