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

²ÉÓÃ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ÎļþÖжÁÈ¡ÅäÖÃÐÅÏ¢

ÈçºÎÔÚSqlserverÖдÓÍⲿXMLÎļþÖжÁÈ¡ÅäÖÃÐÅÏ¢ÄØ£¿¸ÃÎÊÌâÔ´×ÔÒ»¼ÒÆóÒµµÄ±ÊÊÔÐÅÏ¢ÓиС£
Ò»xmlÎļþÄÚÈÝ£º
<?xml version="1.0" encoding="utf-8"?>
<root>
  <db name="ClientDB1" datasize="512MB" datagrowth="100MB" logsize="100MB" loggrowth ="50MB">
  </db>
  <db ......

SQLServer 2005 ³£Óõĺ¯Êý

×Ö·û´®º¯Êý£º
¡ñ¡¡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 ......

02 SQLServer³£Óú¯Êý

/******************************
ϵͳº¯Êý
******************************/

--convert ÓÃÀ´×ª±äÊý¾ÝÀàÐÍ
--convert (data_type[(length)], expression [, style])
select convert(int,convert(varchar(5),12345)+'678')+1 --·µ»Ø12345679
--cast Ò²ÊÇÓÃÀ´×ª»»Êý¾ÝÀàÐÍ
--cast(expression as data_type[(l ......

SQLServerË÷Òýµ÷ÓÅʵ¼ù£¨1£©

Ë÷ÒýµÄÖØÒªÐÔ
Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¾Û´ØË÷Òý
(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý
(Non- Clustered Index)
×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·­µ½Ð»ª×ÖµäµÄº ......

sqlserver¸Ä±äÊÇ·ñÇø·Ö´óСд

²é¿´ÊÇ·ñÇø·Ö´óСд-Ö´Ðд洢¹ý³Ì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
½«²»Çø·Ö´óСд¸ÄÎªÇø·Ö´óСд ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ