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

ÈçºÎѧºÃ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

¶¥Â¥ÉÏ!

ÒýÓÃ
ÓÃC#×ö¸ö´ø½çÃæµÄXX¹ÜÀíϵͳ(´øÊý¾Ý¿âSQL Server2005)


ÕÒ¸öʵ¼ÊµãµÄÏîĿѧϰȥ


Ïà¹ØÎÊ´ð£º

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

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ