Çó½ÌÒ»¸öSql²éѯÎÊÌâ¡£
ÓÐÈý¸ö±íÒ»¸öÊDzɹºµ¥¸ñʽÈçÏÂ
Èë¿âµ¥±í£º
Èë¿âµ¥ºÅ ²úÆ· Öʼì±àºÅ Èë¿âÊýÁ¿
001 Æ·ÖÖ1 Zj001 10
002 Æ·ÖÖ1 Zj002 30
003 Æ·ÖÖ2 Zj003 20
004 Æ·ÖÖ2 Zj004 60
ÖʼìÏîÄ¿±í:
ÖʼìÏîId ÖʼìÏîÃû³Æ
001 º¬ÁòÁ¿
002 º¬Ì¼Á¿
003 º¬ÃÌÁ¿
...
Öʼì±í
Öʼì±àºÅ ÖʼìÏîÄ¿ ÖʼìÖµ
Zj001 001 2
Zj001 002 3
Zj001 003 5
..........
Zj002 001 4
Zj002 002 6
Zj002 003 10
..........
ÆäÖÐÖʼìÏîÄ¿±íµÄÏîÄ¿¿ÉÒÔËæÊ±Ìí¼ÓµÄ¡£µ«ÊDz»¹ÜÌí¼Ó¶àÉÙ¸öÏîÄ¿SQLÓï¾ä¶¼Òª³öÀ´ÒÔϱ¨±íÆäÖÐnÊǶ¯Ì¬µÄ£
Ïà¹ØÎÊ´ð£º
Ö±½ÓÔÚsqlÓï¾äÖÐд£º
sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... "
È»ºó
Rs.open sql,CONN,3,2
Response.Write Rs.recordcount
µ«ÊÇûÓдò¿ª£¬±¨´í
ADODB.Records ......
ÔÌû×Ó£ºhttp://topic.csdn.net/u/20090910/12/813a40a2-922d-4f6a-b30b-a16b9a608f81.html?seed=1336087098&r=59699368#r_59699368
ÏÂÃæµÄ´úÂëÓдíÎóÂð£¿sqlÓï¾äÔÚQueryÖÐÊÇ¿ÉÒÔÖ´Ðгö½á¹ûµÄ¡£
Set C ......
¸÷λ´óÏÀ£ºÇëÎÊÔõÑùÔÚASP³ÌÐòÖе÷ÓÃSQL´æ´¢¹ý³Ì£¿Ð»Ð»£¬Çë¸ø¸öÀý×Ó£¡
http://hi.baidu.com/lz0830/blog/item/e847e5e9077fde39b80e2db9.html
1 ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
set con ......
×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨varchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌâ£ºÍøÕ¾Ð´Êý¾Ý¿âʱ½Å±¾³¬Ê±
Active Server Pages ´íÎó 'ASP 0113' ......
StringBuffer str = new StringBuffer("select * from menu where parentid=1 and mid <>1 order by parentid");
List list = new ArrayList();
ResultSet rst = null;
DataBa ......