SqlServerÖÐ×Ö·ûÐÍת»»ÎªÊý×ÖÐͳöÏîµÄÎÊÌâ

SqlServerÖÐ×Ö·ûÐÍת»»ÎªÊý×ÖÐͳöÏîµÄÎÊÌâ

select  @rno=rno from deleted;
convert(numeric,@rno);
@rno=@rno/1000;

ÏûÏ¢ 156£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì t2£¬µÚ 11 ÐÐ
¹Ø¼ü×Ö 'convert' ¸½½üÓÐÓï·¨´íÎó¡£

---

select  @rno=rno from deleted;
set @rno = cast(@rno as numeric)

---

SQL code:
select @rno=rno from deleted;
SET @rno=convert(numeric,@rno);
SET @rno=@rno/1000;

---

SQL code:
select @rno=rno from deleted;
SET @rno=convert(numeric(18,5),@rno);
SET @rno=@rno/1000;

Éè¼ÆһϾ«¶È

---

ÒýÓÃ

select  @rno=rno from deleted;
set @rno = cast(@rno as numeric)

Ŷ£¡Ô­À´Èç´Ë£¡ÕâÑù²ÅÐУ¡
¿ÉÊÇÕâÑùת¹ýÖ®ºóÓÖ³öÏÖ¸öÎÊÌâ

ÏûÏ¢ 102£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì t2£¬µÚ 12 ÐÐ
'@rno' ¸½½üÓÐÓï·¨´íÎó¡£
ת»»³ÉÊýÖµÐÍÖ®ºóΪʲô²»ÄܽøÐÐÊýѧÔËËãÄØ£¿£¿

---

SQL code:
declare @rno varchar(20)
set @rno=convert(numeric(18,2),@rno);
set @rno=@rno/1000;
select @rno=rno from deleted;

---

SQL code

---

Code highlighting produced by