SQL Server Four Operations

DECLARE 
	@num_1 float,
	@num2 float,
	@total float,
	@subtraction float,
	@Division float,
	@Multiplication float

set @num_1 = 15
set @num2 = 10

set @total = @num_1 + @num2
set @subtraction = @num_1 - @num2
set @Multiplication = @num_1*@num2
set @Division = @num_1/@num2

print 'Total: ' + CAST(@total as varchar(5));
print 'Subtraction: ' + CAST(@subtraction as varchar(5));
print 'Multiplication: ' + CAST(@Multiplication as varchar(5));
print 'Division: ' + CAST(@Division as varchar(5));

Total: 25
Subtraction: 5
Multiplication: 150
Division: 1.5

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a website or blog at WordPress.com

Up ↑

Design a site like this with WordPress.com
Get started