Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä±£´æ
Ϊ¿ÕµÄÎı¾¿ò¶ÔÓ¦µÄ×ֶβ»±£´æ¼´¿É


Ïà¹ØÎÊ´ð£º

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

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


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

¹Ø×¢¡«¡«

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

sqlserver¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.

Ö»¸øSELECT ,

UPDATEµÄÖ»¸øijЩ±í

¸ö²»»á

µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã

Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......

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 ......

SwingÀïÃæµÄʼþÓëSQLserverÊý¾Ý¿âµÄÁ¬½ÓµÄÎÊÌâ

СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍƼöÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐʲôÌرð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.

JDBC

ÇëÎÊÔÚSwingÖмÓÔر³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ