SQL Server calculated column

Question

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

 WinPercentage = (Wins + Losses) / Wins 

What is the syntax for this?

Answer 1

 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 )