ΪÁ˸üºÃµÄ°ïÖú´ó¼Ò ÇëÈý뽫ÄãÃÇ×ܽáµÄsql Óï¾ä´ò¸öѹËõ°ü Ìṩ´ó¼ÒÏÂÔØ°É
ÎÒÃÇ×ªÔØµÄʱºò»á½« ÏÂÃæµÄÄÚÈÝÒ»Æð×ªÔØÉÏÈ¥µÄ£¬Ç°ÌáÄãÃǵÄsqlÓï¾äÉÏÓÐÕâЩ°¡
/*
±êÌ⣺Çå³ýÈÕÖ¾ºÍÊÕËõÈÕÖ¾
×÷Õߣº°®Ð¾õÂ޷ع»ª
ʱ¼ä£º2008-07-14
µØµã£ºÐ½®ÎÚ³ľÆë
×ÊÁÏÀ´Ô´£ºÉîÛÚÍâ¾Ã³¾ÖÄê¼ìÊý¾Ý¿âºÍCSDN»áÔ±adis789×Éѯsql serverÈÕ־Ϊɶ»áÔö³¤ºÜ¿ì£¬
ÓÐÒ»¸ö³ÌÐòÿ5ÃëÖÓдÊý¾ÝÒ»´Î£¬È»ºóÊý¾Ý¿âÈÕÖ¾¾³£Ôö³¤ºÜ¿ì£¬Ôõô±ÜÃâÕâÑùµÄÊÂÇé·¢ÉúÄØ£¿
ÔõôÄÜÈÃsql serverÈÕÖ¾Ôö³¤²»ÒªÕâô¿ì£¬Êý¾ÝÎļþ²Å100MÈÕÖ¾Îļþ¾ÓÈ»1G¶à¡£
*/
ÎÒÔÚÕâÀïÌæ´ó¼ÒллÈýλÁË
´ó¼Ò¶¥Æð°¡
...
學習~~
...
°ï¶¥¡£
學習~~
Õâ¿ÉµÃ·Ñʱ¼äÁË,ÖÁÉÙ½ñÄêÊÇÍê³É²»ÁËÄãµÄÐÄÔ¸ÁË.
¡£¡£¡£
¹þ¹þ ÎÒ¶¼ÊdzϮÎÚ¹êµÄ ÓÐÇëÎÚ¹ê
ÎÒÊÇר³ÌÀ´Ä¤°ÝF椵Ä
ͬÉÏ
ºÇºÇ
ÒªÇóÊDz»Êǹý·ÖÁ˵㰡
ÓÐʱ¼ä¸ø×ܽáϰÉ
ºÇºÇ
ÒªÇóÊDz»Êǹý·ÖÁ˵㰡
ÓÐʱ¼ä¸ø×ܽáϰÉ
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......