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

sql server2000´¦Àíº«ÎÄ

´ó¼ÒºÃ£¬ÔÚsql server2000ÖУ¬
ÓÐÒ»Õűít£¬ÆäÖ»ÓÐÒ»¸ö×Ö¶Î field£¬nvarcharÀàÐÍ
1¡¢ÔÚ²éѯ·ÖÎöÆ÷ÖÐ select '주택 및 자동차' µÄ½á¹ûÊÇÒ»´®Îʺţ»
2¡¢ÔÚ²éѯ·ÖÎöÆ÷ÖÐ insert into t(field) values('주택 및 자동차')Ö®ºó£¬È»ºóselect field from t£¬½á¹ûÒ²ÊÇÒ»´®Îʺţ»
3¡¢Ö±½ÓÔÚÆóÒµ¹ÜÀíÆ÷ÖУ¬ÓÒ¼ü±ít -> ´ò¿ª±í -> ·µ»ØËùÓÐÐУ¬È»ºóÔÚÏàÓ¦×Ö¶ÎÏÂÊÖ¶¯ÌîÈë'주택 및 자동차'£¬È»ºóÔÚ²éѯ·ÖÎöÆ÷ÖÐselect£¬½á¹ûÕý³£ÏÔʾ¡£

ÎÊ£ºÈçºÎͨ¹ý½Å²½·½Ê½²åÈ뺫ÎÄÊý¾Ý£¬Ê¹µÃselect³öÀ´µÄÖµÊÇÕý³£µÄ£¿Ð»Ð»£¬Ð»Ð»~~
ÓëÅÅÐò¹æÔòÓÐ¹Ø ÐèҪȥ²éÏà¹ØµÄ¼¼ÊõÎĵµ

1¡¢Ê¹ÓÃÏàÓ¦µÄÅÅÐò¹æÔò
2¡¢Ê¹ÓÃUnicode±àÂë

½øÀ´Ñ§Ï°

¿ÉÒÔʹÓÃunicode

select N'주택 및 자동차'

insert into t(field) values(N'주택 및 자동차')

¶àл¸÷λ~


Ïà¹ØÎÊ´ð£º

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

ÇóÒ»SQLÓï¾ä

Ô­Êý¾Ý

ÉÌÆ·    Ô­¼Û    ´òÕÛ·½Ê½1  ÕÛ¿Û1    ´òÕÛ·½Ê½2  ÕÛ¿Û2
±Ê¼Ç±¾  10000  NULL        0      NULL&nb ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

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

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


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

¹Ø×¢¡«¡«

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

OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ