34,588
社区成员
发帖
与我相关
我的任务
分享
(cast([round] as int) * 5)/cast(printcnt as int)
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U')) --U 代表你查询的是表
DROP TABLE [TB]
GO
---->建表
create table [TB]([printcnt] int,[round] int)
insert [TB]
select 12,23 union all
select 22,44 union all
select 23,6 union all
select 33,77
GO
--> 查询结果
SELECT *,([round] * 5)/printcnt
FROM [TB]
--> 删除表格
--DROP TABLE [TB]