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

ʵÀýÃû (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 ʵÀýºÍ×é¼þÁÐ±í¡£"ÒѰ²×°ÊµÀýµÄÏêϸÐÅÏ¢"´°¸ñÏÔʾÒѰ²×°ÊµÀýµÄÉý¼¶Ñ¡Ïî¡£ÈôҪѡÔñÓûÉý¼¶µÄ×é¼þ»òʵÀý£¬Çëµ¥»÷ʵÀýÃû£¬È»ºóµ¥»÷"È·¶¨"¡£


Ïà¹ØÎĵµ£º

·À·¶sql×¢Èë¹¥»÷£¨Ï£© ²ÎÊý»¯sql

ÉÏһƪдµÄsql×¢ÈëµÄ»ù±¾Ô­Àí£¬±¾À´Òª½Ó×ÅдÕâÆªµÄ£¬µ«ÊÇÓÉÓÚʱ¼äµÄÔ­ÒòһֱûÓÐд³É£¬½ñÌìÊÇÎåÒ»¼ÙÆÚ£¬×ÜËãÊÇÄܳé¿ÕддÁË¡£
×÷Ϊһ¸ö³ÌÐòÔ±£¬·À·¶sql×¢ÈëµÄµÚÒ»ÏßÊÇÓÉÎÒÃÇÀ´ÊØ»¤µÄ£¬Ö»ÒªÎÒÃÇÔÚ³ÌÐòÖÐÁôÉÙÐíµÄ©¶´£¬¾Í»á¸ø³ÌÐòÔöÇ¿°²È«ÌØÐÔ¡£ËùÒÔÎÒÃÇÒª×öµÄÊÇҪд°²È«µÄ³ÌÐò£¬·ÀÖ¹sql×¢ÈëÔÚ³ÌÐòÌåÏÖÔÚ²»ÒªÆ´½Ósql×Ö·û´®£¬ ......

Éî¶È¶Ô±ÈOracleÓëSQL Server——µÚ¶þ²¿·Ö

Êý¾Ý¿âʵÀý½á¹¹ ÊÂÎñÒ»ÖÂÐÔ(Transactional Consistency)ºÍ»ùÓÚʱ¼äµãµÄ»Ö¸´(Point-in-time Recovery) ϵͳԪÊý¾Ý
topÊý¾Ý¿âʵÀý½á¹¹
µ±OracleʵÀýÆô¶¯Ö®ºó£¬Ëù¿´µ½µÄ¾ÍÊÇÔÚ·þÎñÆ÷ÄÚ´æÉϵÄÒ»¸ö¸ö²»Í¬ÄÚ´æ¿é¼ÓÉϲúÉúµÄÓëÕâЩÄÚ´æ½»»¥µÄºǫ́½ø³Ì¡£OracleÎĵµ½«ÕâЩÄÚ´æ½á¹¹ºÍ½ø³ÌÊյĺÜÏêϸ¡£
ÓÉOracleʵÀýËùÕ¼ÓõÄÄÚ´æ¿é³ ......

SQL ServerÖÐtimestamp£¨Ê±¼ä´Á£©


SQL ServertimestampÊý¾ÝÀàÐÍÓëʱ¼äºÍÈÕÆÚÎ޹ء£SQL ServertimestampÊǶþ½øÖÆÊý×Ö£¬Ëü±íÃ÷Êý¾Ý¿âÖÐÊý¾ÝÐ޸ķ¢ÉúµÄÏà¶Ô˳Ðò¡£ÊµÏÖtimestampÊý¾ÝÀàÐÍ×î³õÊÇΪÁËÖ§³Ö SQL Server »Ö¸´Ëã·¨¡£Ã¿´ÎÐÞ¸Äҳʱ£¬¶¼»áʹÓõ±Ç°µÄ @@DBTS Öµ¶ÔÆä×öÒ»´Î±ê¼Ç£¬È»ºó @@DBTS ¼Ó1¡£ÕâÑù×ö×ãÒÔ°ïÖú»Ö¸´¹ý³ÌÈ·¶¨Ò³Ð޸ĵÄÏà¶Ô´ÎÐò£¬µ«ÊÇtimest ......

ÇÉÓÃSQL PIVOTʵÏÖ»·¾³¼à²âÊý¾ÝµÄ¡°Êúºá¡±×ª»»


Ë®»·¾³¼à²âÊý¾Ý´æ´¢½á¹¹ÖÐÓÐÒ»ÖÖģʽ½Ð×ö"Êú±íģʽ"£¬¼´ÔÚ¼à²âÊý¾Ý±íÖУ¬Ä³¸öµãλÔÚij¸öʱ¼äµãÉϸ÷¼à²âÏîÄ¿µÄŨ¶È²â¶¨ÖµÔÚÎïÀí±íÖд洢ÔÚ¶àÌõ¼Ç¼ÖУ¬³ÊÊú×´·Ö²¼¡£¼à²âÊý¾Ý±íÖаüº¬²âµã´úÂë¡¢¼à²âʱ¼ä¡¢¼à²âÏîÄ¿´úÂ롢Ũ¶È²â¶¨ÖµµÈ£¬ËùÓмà²âÏîÄ¿µÄŨ¶È²â¶¨Öµ¶¼´æ´¢ÔÚͬһ¸ö×Ö¶ÎÖУ¬¼ÓÒÔ¼à²âÏîÄ¿´úÂë×÷ÎªÇø·Ö×ֶΡ£
"Êú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ