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

ÐÂÉú£¬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 µ


Ïà¹ØÎÊ´ð£º

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ