Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sql ÎÊÌâ

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÈçºÎµ÷ÊÔ»òÊä³ö´øSqlParameterµÄsqlÓï¾ä£¿

ÈçºÎµ÷ÊÔ»òÊä³ö´øSqlParameterµÄsqlÓï¾ä£¿
UP

µ÷Óô洢¹ý³Ì£¬ÉèÖÃParameterDirection.Output²ÎÊý
execÔËÐÐsqlÓï¾ä£¬·µ»ØsqlÓï¾ä

ÉèÖöϵ㣬°´ F11 µ¥²½¸ú×Ù..

ParameterDirection.Output
Õâ¸ö²Å¶Ô°É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ