SQL Server计算列 [英] SQL Server Calculated Column

问题描述

我有两列，包括int，赢得和损失。我有一个计算列 WinPercentage 作为十进制（14,3），我希望这是：

I have two columns, both int's, Wins and Losses. I have a calculated column WinPercentage as a decimal(14,3), I want this to be:

WinPercentage = (Wins + Losses) / Wins

这是什么语法？

推荐答案

CREATE TABLE WinLoss
(
 TeamId int IDENTITY(1,1) NOT NULL,
 Wins int,
 Losses int,
 WinPercentage AS CASE WHEN wins > 0 THEN (Wins + Losses) / Wins ELSE 0 END
)

这篇关于SQL Server计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！