ÇóSQLÓï¾ä
ÎÒÓÐÒ»±íÊý¾ÝÈçÏÂ
id Ãû³Æ ÊýÁ¿ µ¥¼Û ½ð¶î ¹©»õÉÌ
1 ±Ê¼Ç±¾ 5 5.00 25.00 AÉÌ
2 ±Ê¼Ç±¾ 10 5.00 50.00 BÉÌ
3 ±Ê¼Ç±¾ 5 5.50 27.50 AÉÌ
4 ±Ê¼Ç±¾ 5 5.50 27.50 BÉÌ
5 Ǧ±Ê 10 2.00 20.00 AÉÌ
6 Ǧ±Ê 15 2.00 30.00 BÉÌ
7 Ǧ±Ê 15 2.20 33.00 AÉÌ
8 Ǧ±Ê 15 2.20 30.00 BÉÌ
9 ±Ê¼Ç±¾ 5 5.00 25.00 AÉÌ
10 ±Ê¼Ç±¾ 10 5.00 50.00 BÉÌ
11 ±Ê¼Ç±¾ 5 5.50 27.50 AÉÌ
12 ±Ê¼Ç±¾ 5 5.50 27.50 BÉÌ
13 Ǧ±Ê 10 2.00 20.00 AÉÌ
14 Ǧ±Ê 15 2.00 30.00 BÉÌ
15 Ǧ±Ê 15 2.20 &
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......