求一个简单的视图语句！谢谢！
CREATE view view_文档统计_视图
as
select 名称,
str(文档总数) as 文档总数,
str(借阅中文档) as 借阅中文档,
from view_文档统计
如上：我想把“文档总数”改为整型，怎么写？
多谢！
[解决办法]
CREATE view view_文档统计_视图
as
select 名称,
cast(str(文档总数) as int) as 文档总数,
str(借阅中文档) as 借阅中文档,
from view_文档统计
go
