Multiplying Two Columns in SQL Server

Question

How can I perform operations such as Multiplying and Subtracting two columns in SQL Server?

Payment PK - PaymentID FK - PaymentTypeID FK - OccupiedApartmentID    **- InitalPayment    - MonthlyRate    - Balance**    - PaymentDate 

Answer 1

In a query you can just do something like:

SELECT ColumnA * ColumnB FROM table 

or

SELECT ColumnA - ColumnB FROM table 

You can also create computed columns in your table where you can permanently use your formula.