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

¹ØÓÚsqlserver»õ±ÒÐÍ×Ö¶ÎÏÔʾµÄÎÊÌâ

´ó¼ÒºÃ,СµÜÓÖÓöÒ»ÐÂÎÊÌâ:

VB+SQL

ÓÐN¸ö×Ö¶Î,´°ÌåÉÏÓÐN¸ötext.±£´æÊäÈë½á¹ûºó,ÓÐN¸ö¶ÔӦΪ»õ±Ò×ԶεÄtextÔÚûÓÐÊäÈëÈκÎÖµ(¼´Îª¿Õ)µÄÇé¿öÏÂ,´ÓSQL²éѯ·ÖÎöÆ÷Àï²éµ½,Æä¾ÓÈ»ÊÇ"0.00".

¶øÇÒ½«Æä¶Á³öµ½TEXT¿òÄÚÒ²ÏÔʾΪ 0,ÏÖÎÒÏëÔÚ¶Á³öÊý¾ÝµÄʱºò,ÓÐÊý¾ÝµÄÏÔʾÊý¾Ý,¶øÎª 0 µÄÊýÖµ²»ÏÔʾÓÚÎı¾¿òÄÚ,¼´Îı¾¿òÄÚ¾ÍΪ¿Õ,²»ÏÔʾ"0".

ÇëÎʸ÷λ´óÏÀÓз¨×ÓÂð?
if rs.fields("mymoney")=0 then
    text1=""
else
    text1=rs.fields("mymoney")
end if


лл´ð¸´,ÎÊÌâÊÇÎÒÓÐ20¶à¸ötext°¡

Òª¼ò±ã£¬¿ÉÒÔÓÃÒ»¸ö¹ý³Ì±éÀútext£¬Åжϲ¢Ð޸쬵«ÊÇÕâÑù×öÏîÄ¿²»ºÃ

ÒýÓÃ
»òÕßÓÃsqlÓï¾ä¿ØÖÆ

select id
    , (case mymoney
          when 0 then ''
          else mymoney
        end
      ) as mymoney
from mytable


Õâ¸ö¿ÉÒÔ

²»ÒªÓÃÎı¾¿òÊý¾Ý°ó¶¨,ÓÃsqlÓï¾ä±£´æ
Ϊ¿ÕµÄÎı¾¿ò¶ÔÓ¦µÄ×ֶβ»±£´æ¼´¿É


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

jspÖÐsqlserver2005²éѯµÄ·µ»ØÖµ

ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ­»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ
ÓÃList²»ÐÐÂð£¿

ÓÃlist

Ò³ÃæÓà <c:forEach& ......

php+sqlserver È¡¼Ç¼ʱµÃµ½idµÄÎÊÌ⣬ÔÚÏßµÈ

ÒÑÖª sql serverÖÐ
$server="se";
$username="us";
$password="pa";
$datebase="ds";

1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ