ÈçºÎѧºÃC#ºÍSQL2005
ÎÒѧϰC#ºÍsql2005ÓаëÄêÁË µ«ÊÇÎÒ¾õµÃÎÒ»¹ÊÇûÓÐѧµ½Ê²Ã´£¿Ö»»áһЩ¼òµ¥µÄ³ÌÐò£¬Çë¸÷λ¸ßÊÖÖ¸Ìõ· ÎÒÏÂѧÆÚҪѧµÄÊÇwinformµÄ¿ª·¢ºÍguiµÄ¿ª·¢£¬¶ÔÁË ÎÒÊÇѧniitµÄ
ÏÈѧ»áËÑ»ê´ó·¨£¬È»ºóÕÒ¸ö»áµÄÈ˶ÁÈ¡±ðÈ˵ļÇÒä¡£OVER
http://forum.csdn.net/BList/MSSQL/
http://forum.csdn.net/BList/MSSQL/
ÄãÓ¦¸ÃÈ¥»ìÕâ¸ö2¸öÇø
ÓÃC#×ö¸ö´ø½çÃæµÄXX¹ÜÀíϵͳ(´øÊý¾Ý¿âSQL Server2005)
LZѽ ÄãÓ¦¸Ãµ½C# ºÍ SQL°æÌáÎʰÉ
Çë½áÌùÍêÔÙÈ¥£¬ok
¶¥Â¥ÉÏ!
ÕÒ¸öʵ¼ÊµãµÄÏîĿѧϰȥ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......