SQL Mathematica – How to get the Area & Circumference of a Circle – SQL Circuit

SQL Mathematica – How to get the Area & Circumference of a Circle

This simple stored procedure calculates the area & circumference of a circle using radius—an ideal example for beginners. It’s designed to spark interest in those just starting their journey with SQL Server and T-SQL programming.

/********************************************************************
Description  : Procedure to calculate Area and Circumference of a Circle

 Definition   : 
 - Area of Circle = π × Radius²  
   Represents the total surface covered inside the boundary of the circle.

 - Circumference of Circle = 2 × π × Radius  
   Represents the total distance around the circle (its perimeter).

 Purpose      :
 - Accepts the radius as input
 - Calculates both area and circumference of the circle
 - Returns results using OUTPUT parameters

 Parameters   :
 - @Radius         [INPUT]  : Radius of the circle
 - @Area           [OUTPUT] : Calculated area using π × r²
 - @Circumference  [OUTPUT] : Calculated circumference using 2 × π × r
 ********************************************************************/
CREATE PROCEDURE dbo.Calculate_Circle_Area_Circumference
    @Radius FLOAT,
    @Area FLOAT OUTPUT,
    @Circumference FLOAT OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @PI FLOAT = 3.14159265;

    SET @Area = @PI * @Radius * @Radius;
    SET @Circumference = 2 * @PI * @Radius;
END

Execution of Stored Procedure

USE [BI_Reporting]
GO

DECLARE	@return_value int,
		@Area float,
		@Circumference float

EXEC	@return_value = [dbo].[Calculate_Circle_Area_Circumference]
		@Radius = 5,
		@Area = @Area OUTPUT,
		@Circumference = @Circumference OUTPUT

SELECT	@Area as N'Area of Circle',
		@Circumference as N'Circumference  of Circle'

SELECT	'Return Value' = @return_value

GO

Leave a Reply

Your email address will not be published. Required fields are marked *