ÐÂÉú£¬Win7£¬¸ÃÑ¡Ôñʲô°æ±¾SQL£¿
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ·ñ×°ÆäËû°æ±¾µÄSQL£¬SQL 2005Ìý˵ÓмæÈÝÎÊÌ⣬ҪװSP3²¹¶¡£¬SQL 2008 òËÆÍêÈ«¼æÈÝ£¬SQL 2005ºÍ 2008µÄ²î±ð´óÂð£¿
ÎÒÓùýVS 2005 ºÍ VS 2008£¬ÏÖÔÚÔÚÓÃVS 2008£¬¸Ð¾õ¾ÍÎÒÕâÖÖ³õѧÕßÓõ½µÃ¹¦ÄÜÀ´Ëµ£¬²î±ð²»´ó£¬»ù±¾Ò»ÑùµÄ²Ù×÷£¬²»ÖªµÀSQL 2005 ºÍ SQL 2008 ²î±ðÈçºÎ
»¹ÓУ¬SQL 2000 ºÍ SQL 2005 ²î±ðÌý˵Óеã´ó£¨Ã²ËÆ˵ʲôÓï·¨¶¼ÓÐÇø±ð£¬ÕæµÄô£¿£©
Çë¾ÑéÈËÊ¿¸øСµÜÖ¸µãÏÂÀ²
http://passport.csdn.net/ActivateUser.aspx?UserName=liweilovexue8543&Code=t8uuQn%2fLS9L8FRDkF12K9oDjgsjvwmINiYcw%2boYSx9S%2fV9nIEwLNl7uSix7PzsxeAfCC134xr%2fNihyIXa0X8ZtNL32iKMUp1
¶ÔÁË£¬Èç¹û×°SQL£¬¾ßÌå¸Ãװʲô°æ±¾£¿¸öÈ˰棿ÆóÒµ°æ£¿¿ª·¢°æ£¿£¨²»Òª¼òÒװ棩
2008 Æƽâ°æ
SQL SERVER2008 ºÍ SQL SERVER 2005Ïà²î²»ÊǺܴó.
°²×°¿ª·¢°æ¾Í¹»ÁË,SQL SERVER2008ÆóÒµ°æ¹À¼ÆÒª°²×°WIN7 ÆóÒµ°æ»òÕßÆì½¢°æ²Å¿ÉÒÔ°²×°.
¸øÄã¸ö×îÍêÈ«µÄ»Ø´ð°É£¡
ÓÉÓÚÆ®Ò×ÊÖÀïÓÐÏîÄ¿ÐèÒªÓõ½Microsoft SQL Server 2005Êý¾Ý¿â£¬µçÄÔÀïÔÓеÄmssql2000ÒѾ²»ÊÊÓÃÁË£¬µ½ÍøÉÏÑ°ÕÒ SQL Server 2005¼òÌåÖÐÎÄ¿ª·¢°æµÄÏÂÔصØÖ·£¬Ò»¿ªÊ¼ÏÂÔØÁ˸öѧϰ°æµÄexpress£¬¿ÉÏÞÖÆÌ«¶à£¬»¹ÊǾöÐÄ°²×°¿ª·¢°æ±¾µÄ¡£
µ½Î¢ÈíµÄ¹Ù·½ÍøվѰÕÒÁËһЩÊÚȨ×ÊÁÏ£¬ÌùÔÚÏÂÃ棺
Microsoft SQL Server 2005 ¿ª·¢°æʹ¿ª·¢ÈËÔ±Äܹ»ÔÚ32λºÍX64ƽ̨µÄ»ù´¡ÉϽ¨Á¢ºÍ²âÊÔÈÎÒâÒ»ÖÖ»ùÓÚSQL Server µ
Ïà¹ØÎÊ´ð£º
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN
¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª
ÐÕÃû ¿ÆÄ¿ ³É¼¨
ÕÅÈý Ó¢Óï 90
ÀîËÄ Ó¢Óï&nb ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......