sql nullÎÊÌâ
µ±¸ø server sql Êý¾Ý¿âÌí¼ÓÒ»ÐÐʱ ÏëʹÐÐΪ null µÄÓòֵΪ 0
ÔÚ server sql Êý¾Ý¿âÉè¼Æ±íÀï ʹÓòµÄĬÈÏֵΪ (0) ͨ¹ýc#³ÌÐòÌí¼ÓÐÐʱÒÀÈ»ÊÇnull
ÏÖÔÚÎÒÏëͨ¹ý´¥·¢Æ÷ À´ÊµÏÖ
A ±í A±í
------------------------ ʵ¼ÊÏëÿÌí¼Ó1ÐÐ ½á¹ûΪ ------------------------------------
Ãû³Æ ÊýÁ¿1 ÊýÁ¿2 Ãû³Æ ÊýÁ¿1 ÊýÁ¿2
ÓñÃ× 10 null ÓñÃ× 10 0
СÂó null 20 СÂó 0 20
Ò²¾ÍÊÇnull ÔÚÌí¼ÓʱΪ0
Çë½Ì
not null default 0
isnull(Öµ,0)
SQL code:
if object_id('[A]') is not null drop table [A]
go
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......