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

ÇëÎÊ£¬ÍâÍøÈçºÎÁ¬µ½ÄÚÍø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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

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

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

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ