SqlServer中字符型转换为数字型出项的问题！

declare @rnoInt int;
declare @rnoX varchar(20),@rnoJ varchar(20),@rno varchar(20);
select  @rno=rno from deleted;
set @rnoInt = cast(@rno as numeric);
@rnoInt=@rnoInt/1000

消息 102，级别 15，状态 1，过程 t2，第 15 行
'@rnoInt' 附近有语法错误。

---

SQL code:
declare @rnoInt int;
declare @rnoX varchar(20),@rnoJ varchar(20),@rno varchar(20);
select @rno=rno from deleted;
set @rnoInt = cast(@rno as numeric(19,4));
SET @rnoInt=@rnoInt/1000

---

SQL code:

declare @rnoInt int;
declare @rnoX varchar(20),@rnoJ varchar(20),@rno varchar(20);
select @rno=rno from deleted;
set @rnoInt = cast(@rno as numeric);
set @rnoInt=@rnoInt/1000 --少set

---

SQL code:
declare @rnoInt int;
declare @rnoX varchar(20),@rnoJ varchar(20),@rno varchar(20);
select @rno=rno from deleted;
set @rnoInt = cast(@rno as numeric);
set @rnoInt=@rnoInt/1000

---

晕  刚才的帖子里面我写的是正确的

---

好像刚才有一帖了

---

引用

好像刚才有一帖了

谢谢啦啊！！