declare @val decimal (5, 2)
set @val = 193.57
select cast(@val as varbinary(20)),cast(cast(@val as varbinary(20))
as varbinary(10,5))
--或用 CONVERT
Select convert(varbinary(20), @val),convert(DECIMAL(10,5),
convert(varbinary(20), @val))
统计演员表(yanyuan)中平均工资avg()
先使用游标修改演员(yanyuan)表里工资那个字段里的数据:
DECLARE yanyuan_cursor CURSOR --声明游标
FOR select yid,sa from yanyuan
FOR UPDATE of sa
DECLARE @gz int
SET @gz=100
OPEN yanyuan_cursor --打开游标
FETCH NEXT FROM yanyuan_cursor --提取游标
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
UPDATE yanyuan
SET sa = sa+@gz,
@gz=@gz+@gz*0.5
WHERE CURRENT OF yanyuan_cursor
END
FETCH NEXT FROM yanyuan_cursor --INTO @name
END
CLOSE yanyuan_cursor --关闭游标
DEALLOCATE yanyuan_cursor --释放游标
GO
然后再查下平均工资多少:
select '平均工资'=avg(sa)
from yanyuan
查询结果如下: