sql±¨´í - MS-SQL Server / Ó¦ÓÃʵÀý

ÊÇÕâÑùµÄ£¬ÎÒÓÐÒ»¶ÎSQL³ÌÐò±¨´í£¬ÆäÖгö´íµÄÒ»¾äÊÇ
sum(case when n.nbjbsq020=1 then n.nbjbsq015 else 0 end) ps
±¨´íµÄÄÚÈÝÊÇ
ÏûÏ¢ 245£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÔÚ½« nvarchar Öµ '7.0' ת»»³ÉÊý¾ÝÀàÐÍ int ʱʧ°Ü¡£
ÎÒ±¾À´³õ²½·ÖÎöÊÇת»»Êý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓÚÊÇÎÒ°Ñ´úÂë¸ÄΪ
sum(case when cast(n.nbjbsq020 as int)=1 then n.nbjbsq015 else 0 end) ps
µ«ÎÊÌâÒÀ¾É´æÔÚ£¬È»ºóÎÒ³¢ÊÔ°ÑÕâ¾ä»»Îª
sum(n.nbjbsq020) ps
½á¹ûû±¨´í£¬ÄÚÈÝÊÇ¿ÉÒÔÏÔʾµÄ£¬ÄÇΪʲôÓÃ×îÉÏÃæÄǾ䲻ÐÐÄØ£¿

---

nbjbsq015 Õâ¸öÁÐÀïÓзǷ¨Êý¾Ý

---

SQL code:
sum(n.nbjbsq015)


Ö»ÊÇÕâÑù»á±¨´íÂð

---

SQL code:
select nbjbsq015 from tb where isnumeric(nbjbsq015)=0


ÓÃÕâ¾ä°Ñ·ÇÊýÖµÐ͵ÄÕÒ³öÀ´

---

SQL code:
sum(case when cast(n.nbjbsq020 as dec(18,1))=1.0 then n.nbjbsq015 else 0 end) ps

---

ÒýÓÃ

nbjbsq015 Õâ¸öÁÐÀïÓзǷ¨Êý¾Ý

SQL code:
²»ÊÇÓзǷ¨Êý¾Ý
declare @t nvarchar(10)
select @t='7.0'
select cast(@t as int)
/*
訊Ï¢ 245£¬層