ʵÀýÃû (SQL Server Express)
ʹÓà Microsoft SQL Server °²×°Ïòµ¼µÄ"ʵÀýÃû"Ò³£¬¿ÉÖ¸¶¨´´½¨Ä¬ÈÏʵÀý»¹ÊÇ´´½¨ SQL Server Express ÃüÃûʵÀý¡£³ý·ÇÄúÑ¡ÔñĬÈÏʵÀý£¬·ñÔò SQL Server Express ½«Ê¼ÖÕ°²×°ÃüÃûʵÀý (SQLExpress)¡£´ËÐÐΪÓë SQL Server 2005 ²»Í¬£¬ºóÕßÔÚδѡÔñÃüÃûʵÀýµÄÇé¿öÏ£¬½«Ê¼ÖÕ°²×°Ä¬ÈÏʵÀý¡£
Ñ¡Ïî
Ñ¡Ïî
˵Ã÷
ĬÈÏʵÀý
Èç¹ûÑ¡Ôñ"ĬÈÏʵÀý"£¬¶ø¼ÆËã»úÉÏÒѾ´æÔÚĬÈÏʵÀý£¬Ôò SQL Server °²×°³ÌÐò½«Éý¼¶¸ÃĬÈÏʵÀý¡£ÇëÑ¡Ôñ´ËÑ¡ÏîÀ´°²×° SQL Server Express µÄĬÈÏʵÀý¡£Ò»Ì¨¼ÆËã»úÖ»ÄܳÐÔØÒ»¸öĬÈÏʵÀý¡£
×¢Ò⣺ĬÈÏʵÀýÃûΪ MSSQLSERVER£»Ëü²»ÐèÒª¿Í»§¶ËÖ¸¶¨ÊµÀýÃû³Æ¼´¿É½¨Á¢Á¬½Ó¡£
ÈôÒªÉý¼¶ÔçÆÚ SQL Server °²×°µÄĬÈÏʵÀý£¬Çëµ¥»÷"ĬÈÏʵÀý"£¬È»ºóµ¥»÷"ÏÂÒ»²½"¡£
ÃüÃûʵÀý
ÔËÐÐ SQL Server Express ʱ£¬Ä¬ÈÏÇé¿öϽ«Ñ¡ÖÐÒÑÃüÃûµÄʵÀýÑ¡Ï²¢ÇÒʵÀýÃûΪ SQLExpress¡£
ÇëÑ¡Ôñ´ËÑ¡ÏîÀ´´´½¨ÐÂÃüÃûʵÀý¡£ÃüÃû SQL Server ʵÀýʱ£¬Ç뿼ÂÇÒÔÏÂÊÂÏ
ʵÀýÃû²»Çø·Ö´óСд¡£
ʵÀýÃû²»ÄÜ°üº¬ Default¡¢MSSQLServer »òÆäËû±£Áô¹Ø¼ü×Ö¡£Èç¹ûÔÚʵÀýÃûÖÐʹÓÃÁ˱£Áô¹Ø¼ü×Ö£¬Ôò½«·¢Éú´íÎó¡£
ʵÀýÃûÏÞÖÆΪ 16 ¸ö×Ö·û¡£
ʵÀýÃûµÄÊ××Ö·û±ØÐëÊÇ×Öĸ»òÏ»®Ïß (_)¡£¿É½ÓÊܵÄ×ÖĸΪ Unicode ±ê×¼ 2.0 Öж¨ÒåµÄ×Ö·û£¬°üÀ¨À¶¡×Ö·û a-z ºÍ A-Z£¬ÒÔ¼°Ô´ÓÚÆäËûÓïÑÔµÄ×Öĸ×Ö·û¡£
ºóÐø×Ö·û¿ÉÒÔÊÇ Unicode ±ê×¼ 2.0 ¶¨ÒåµÄ×Öĸ¡¢Ô´ÓÚ»ù±¾À¶¡Óï»òÆäËû¹ú¼Ò/µØÇøÊéд·ûºÅµÄÊ®½øÖÆÊý×Ö¡¢ÃÀÔª·ûºÅ ($) »òÕßÏ»®Ïß (_)¡£
ʵÀýÃûÖв»ÔÊÐíÓÐÆäËûÌØÊâ×Ö·ûµÄǶÈë¿Õ¸ñ£»Ò²²»ÔÊÐíÓз´Ð±¸Ü (\)¡¢¶ººÅ (,)¡¢Ã°ºÅ (:)¡¢·ÖºÅ (;)¡¢µ¥ÒýºÅ (')¡¢"and"·û (&)¡¢Êý×Ö·ûºÅ (#) »ò"at"·ûºÅ (@)¡£
×¢Ò⣺ֻÓÐÔÚµ±Ç° Microsoft Windows ´úÂëÒ³ÖÐÓÐЧµÄ×Ö·û²ÅÄÜÔÚ SQL Server ʵÀýÃûÖÐʹÓá£Èç¹ûʹÓÃÁ˲»Ö§³ÖµÄ Unicode ×Ö·û£¬½«»á·¢Éú´íÎó¡£
ÒÑ°²×°µÄʵÀý
ʹÓà SQL Server °²×°Ïòµ¼µÄ"ÒÑ°²×°µÄʵÀý"Ò³£¬¿ÉÒԲ鿴ÔËÐÐ SQL Server °²×°³ÌÐòµÄ¼ÆËã»úÉÏÒÑ°²×°µÄ SQL Server Express ʵÀýºÍ×é¼þÁÐ±í¡£"ÒÑ°²×°ÊµÀýµÄÏêϸÐÅÏ¢"´°¸ñÏÔʾÒÑ°²×°ÊµÀýµÄÉý¼¶Ñ¡Ïî¡£ÈôҪѡÔñÓûÉý¼¶µÄ×é¼þ»òʵÀý£¬Çëµ¥»÷ʵÀýÃû£¬È»ºóµ¥»÷"È·¶¨"¡£
Ïà¹ØÎĵµ£º
ͬ²½Ò»ÏÂÎÒbaiduµÄblog£ºhttp://hi.baidu.com/ncheng/blog/item/bc65f82a1a6a7c335343c11c.html
Sql×¢ÈëÊÇÒ»ÖÖÈëÃż«µÍÆÆ»µ¼«´óµÄ¹¥»÷·½Ê½¡£Èç¹ûsqlÊÇÓÃ×Ö·û´®Æ´½Ó³öÀ´µÄ»°£¬ÄÇô¿Ï¶¨»á±»×¢Èë¹¥»÷£¬Ç°¶Îʱ¼ä»¹´«³öÁËij¹úÍâ´óÐÍÉç½»ÍøÕ¾±»SQL×¢Èë¹¥»÷¡£
Sql×¢Èë¹¥»÷µÄ·½Ê½£¬À´ÕâÀï¿´µÄͬ־ÃÇÓ¦¸ÃºÜÇå³þÁË£¬¾ÍÊÇÔÚÆ´½Ó×Ö·û´ ......
SQL Server ϵͳȫ¾Ö±äÁ¿
@@CONNECTIONS
·µ»Ø×ÔÉÏ´ÎÆô¶¯ÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý¡£
@@CURSOR_ROWS
·µ»ØÁ¬½ÓÉÏ×îºó´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñÐеÄÊýÁ¿(·µ»Ø±»´ò¿ªµÄÓαêÖл¹Î´±»¶ÁÈ¡µÄÓÐЧÊý¾ÝÐеÄÐÐÊý)
@@DATEFIRST
·µ»ØÿÖܵÚÒ»ÌìµÄÊý×Ö
@@ERROR
·µ»Ø×îºóÖ´ÐеÄSQL Óï¾äµÄ´íÎó´úÂë¡£
@@FETCH_STATUS
·µ»Ø ......
Transact-SQL ÓïÑÔʹÓõÄÁ÷³Ì¿ØÖÆÃüÁîÓë³£¼ûµÄ³ÌÐòÉè¼ÆÓïÑÔÀàËÆÖ÷ÒªÓÐÒÔϼ¸ÖÖ¿ØÖÆÃüÁî¡£
4.6.1 IF…ELSE
Æä
Óï·¨ÈçÏ£º
IF <Ìõ¼þ±í´ïʽ>
<ÃüÁîÐлò³ÌÐò¿é>
[ELSE [Ìõ¼þ±í´ïʽ]
<ÃüÁîÐÐ
»ò³ÌÐò¿é>]
ÆäÖÐ<Ìõ¼þ±í´ïʽ>¿ÉÒÔÊǸ÷ÖÖ±í´ïʽµÄ×éºÏ£¬µ«±í´ïʽµÄÖµ±ØÐëÊÇÂß¼Öµ“Õæ&rdq ......
sql Ìí¼ÓзÖÇø
ALTER PARTITION SCHEME SCH_Source_ID_DT_ID
NEXT USED sn3
go
ALTER PARTITION FUNCTION [PF_Source_ID_DT_ID]()
SPLIT RANGE ('350000')
ɾ³ý·ÖÇø
±à¼
ALTER PARTITION FUNCTION [PF_Source_ID_DT_ID]( ......