且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL Server计算列

更新时间:2022-12-09 13:17:38

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
)