ÇëÎÊ£¬ÍâÍøÈçºÎÁ¬µ½ÄÚÍøsqlÊý¾Ý¿â
ÊÇÕâÑùµÄ
ÎÒµ¥Î»ÊÇÓà adslÉÏÍø£¬ ·ÓÉÊÇÓÃµÄ tp-link d410µÄ£¬
µ¥Î»ÓÐÁ½Ì¨µçÄÔ£¬ÆäÖÐһ̨×ö·þÎñÆ÷Óã¬×°ÓÐ sql-server
2000
ÏÖÔÚÎÒÏëÔÚÍâÍøÁ¬½Óµ½ÎÒµÄ ·þÎñÆ÷ÉϵÄsqlÊý¾Ý¿â¡£
ÎÒÒѾÔÚ·þÎñÆ÷ÉÏ×°ÁËÒ»¸ö »¨Éú¿ÇÈí¼þÀ´È¡µÃ¹Ì¶¨µÄµØÖ·
ÔÚÄÚÍø£¬Ò²¾ÍÊÇÁíһ̨µçÄÔ£¬ÎÒÓà ÄÚÍøIPÁ¬sqlÊÇûÎÊÌâµÄ£¬µ«ÊÇ ÎÒÓû¨Éú¿ÇµÃµ½µÄµØÖ·Á¬sql¾ÍÁ¬²»ÉÏ£¬ÄÚÍøµçÄÔºÍÍâÍøµçÄÔ¶¼Á¬²»ÁË£¡
ÇëÎÊ£¬ÎÒÓ¦¸ÃÈçºÎÉèÖà ²ÅÄÜÈÃÍâÍøÁ¬½Óµ½ÄÚÍø·þÎñÆ÷µÄsqlÄØ£¿
=================================================
Åųý¿ÉÄÜ£º
·À»ðǽ£¬£¨·þÎñÆ÷ÉÏÎÒ°Ñ·À»ðǽȫ¶¼¹ØµôÁËҲûÓã©
Ôø¾ÉèÖùý£º
ÎÒÔÚ·ÓÉÉÏÉèÖà ¶Ë¿ÚÓ³É䣬ӳÉäµ½1433¶Ë¿Ú£¬Ò²ÊÇûÓá£
Ôø¾ÉèÖùý£º
ÎÒÔÚ·ÓÉÉÏÉèÖà ¶Ë¿ÚÓ³É䣬ӳÉäµ½1433¶Ë¿Ú£¬Ò²ÊÇûÓÃ
----------
Òª°ÑÊý¾Ý¿â·þÎñÆ÷¶ÔÓ¦µÄ1433Ó³Éä³öÈ¥²ÅÓÐÓÃ
¹À¼ÆÂ·ÓÉÆ÷ÓÐÎÊÌ⣬»¹ÓУ¬¼ì²éÄãµÄSQLÆôÓõÄÊDz»ÊÇ1433¶Ë¿Ú£¬ÔÚÓÐЩʱºò°²×°ÓõIJ»ÊÇ1433£¬±ÈÈç°²×°µÄ·þÎñÆ÷ʵÀý
Êý¾Ý¿â¾ÍÊÇ 1433¶Ë¿Ú£¬
----------
Òª°ÑÊý¾Ý¿â·þÎñÆ÷¶ÔÓ¦µÄ1433Ó³Éä³öÈ¥²ÅÓÐÓÃ
Õâ¸öÊÇʲôÒâ˼£¿Ó¦¸ÃÈçºÎ²Ù×÷ÄØ£¿
È¥²éһϠnat ¶Ë¿ÚÓ³Éä
ÎÒÌý˵¹ý½Ó¿Ú»úµÄÀý×Ó£¬ÊÇÎÒÏ븴ÔÓÁË
1.È·¶¨ÏÂÄãµÄÊý¾Ý¿â·þÎñÆ÷¶Ë¿ÚÊDz»ÊÇ1433
2.ÄãÄÚÍøÁ´½ÓÊý¾Ý¿â·þÎñÆ÷ûÓÐÎÊÌ⣬˵Ã÷ÎÊÌâûÓгöÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¡
ÍÆ¶Ï¿ÉÄÜÎÊÌâ³öÏÖÄã·ÓɵĶ˿ÚÓ³ÉäÉÏ£¬ÄãÔÚÍâÍøTELNET Êý¾Ý¿â¶Ë¿Ú£¬¿´¿´ÊDz»ÊÇͨµÄ£¡
·½ÏòÊÇÕâ¸ö·½Ïò£¡
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......