Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mssql

Ë­ÓÐMSSQLÊý¾Ý¿â£¬·À×¢ÈëµÄ´úÂ룿??

ÕâÊÀ½çÌ«¿ÉЦÁË£¡£¡£¡

ËÑË÷µÄÈ«²¿¶¼²»ÄÜÓã¬À´ÕâÀïÕÒÈ˽â¾ö·Ä×¢ÈëµÄÎÊÌ⣬ûÈËÄܸø¸öºÃʹµÄ·À×¢Èë´úÂ룿
ȷʵ¿ÉЦ,²»¹ý²»ÊÇÕâ¸öÊÀ½ç

<%


'--------¶¨Ò岿·Ý------------------
Dim Neeao_Application_Value
Dim Neeao_Post,Neeao_Get,Neeao_Inject,Neeao_Inject_Keyword,Neeao_Kill_IP, ......

MSSQL¿Í»§»úÉϽ»Êý¾Ý

Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,ËøסÖ÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀ뼶±ð

Äã²åÄãµÄ,Ëû²åËûµÄ,Ë­Ò²²»°­Ë­.
¹Ø¼üÔÚÓÚÄãµÄ·þÎñÆ÷µµ´ÎÊÇ·ñ¹»¸ß?

ѧϰ

SQL×Ô¼ºµÄËø»úÖÆÒѾ­¹»ÓÃÁË

ÒýÓÃ
Äã²å ......

mssql°²È«ÎÊÌâ

ÎÒ×öÁËÒ»¸öÍøÕ¾£¬ÆäÖÐʹÓÃÁËÒ»¸ö´æ´¢¹ý³Ì,ÏÂÃæµÄÊǵ÷Óô洢¹ý³ÌµÄ´úÂë
Set MyComm = CreateObject("ADODB.Command")
with MyComm
.ActiveConnection = cn 'MyConStrÊÇÊý¾Ý¿âÁ¬½Ó×Ö´®
.CommandText = "dt_user" 'Ö¸¶¨´æ´¢¹ý³ÌÃû
.CommandType = 4 '±íÃ÷ÕâÊÇÒ»¸ö´æ´¢ ......

mssql ʱ¼ä±È½ÏÎÊÌâ

Êý¾Ý¿â½á¹¹£º
        id      hit      times
1 1 2008Äê2ÔÂ19ÈÕ
2 26 2008Äê2ÔÂ27ÈÕ
3 32 2008Äê2ÔÂ27ÈÕ

select sum(hit)as wk,times from hit where id=1005 group by times
µÃµ½½á¹û£º
1 2009Äê12ÔÂ10ÈÕ
2 2009Äê12ÔÂ16ÈÕ
1 2 ......

MSSQL2000+ASP¹ØÓÚÊÂÎñµÄ´¦Àí£¡£¡£¡£¡£¡£¡£¡

ÎÊÌâ¸ÅÊö£º
µç×ÓÉÌÎñÍøÕ¾£¬¼¯³ÉÁË¿ìÇ®µÄÖ§¸¶½Ó¿Ú
µ±Óû§´ÓÎÒÃÇÍøÕ¾·¢ÆðÖ§¸¶ÇëÇóµÄʱºò£¬Èç¹ûÖ§¸¶³É¹¦£¬¿ìÇ®»áͬʱGETºÍPOST¸øÎÒÃÇ·þÎñÆ÷Ö§¸¶³É¹¦µÄÐÅÏ¢
Ö±µ½ÎÒÃÇ·þÎñÆ÷ÏìÓ¦ÊÕµ½ÎªÖ¹£¬È»ºóÎÒÃÇÍøÕ¾¼Ç¼´ËÈ˵IJÆÎñÃ÷ϸ¡£

µ«ÊÇÓÐÒ»¸öÎÊÌ⣬ºÜÉÙºÜÉÙµÄÇé¿öÏ£¬ÎÒÃÇÍøÕ¾µÄ³ÌÐò»á¶à¸øÓû§ÔÚÎÒÃÇÍøÕ¾µÄ²ÆÎñÕʺÅÀï¶ ......

ÓÃmssqlÔõÑùʵÏÖÕâÑùµÄЧ¹û

ÏÂÃæÊǼÆË㵱ǰ»ý·ÖµÄsqlÓï¾ä£ºÈç¹û¼Ç¼ΪnullʱÏÔʾ0

select isnull('0',(b.sumpoints - a.usedpoints)) as points

½á¹û£ºËùÓмǼ¶¼ÏÔʾ 0

Èç¹û£º
select (b.sumpoints - a.usedpoints) as points
È´³öÏÖnull
ÇëÎÊÔõÑù½«ÕâЩnull±ä³É0ÄØ£¿
select isnull((b.sumpoints - a.usedpo ......
×ܼǼÊý:200; ×ÜÒ³Êý:34; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [13] [14] [15] [16] 17 [18] [19] [20] [21] [22]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ