SQL Server DEGREES()

SQL Server DEGREES() Function

The SQL Server DEGREES() function converts an angle from radians to degrees. This function is useful for converting radian measurements to degree measurements in trigonometric calculations.

Syntax

SELECT DEGREES(angle_in_radians);

The DEGREES() function takes a single argument:

  • angle_in_radians: The angle in radians to be converted to degrees.

Example SQL Server DEGREES() Function Queries

Let's look at some examples of SQL Server DEGREES() function queries:

1. Basic DEGREES() Example

SELECT DEGREES(PI()) AS result;

This query converts the angle π radians to degrees. The result will be:

result
------
180

2. DEGREES() with π/2 Radians

SELECT DEGREES(PI()/2) AS result;

This query converts the angle π/2 radians (90 degrees) to degrees. The result will be:

result
------
90

3. DEGREES() with a Column

SELECT angle_in_radians, DEGREES(angle_in_radians) AS angle_in_degrees
FROM angles;

This query converts the angles in the angle_in_radians column to degrees for each record in the angles table. The result will show the original angle_in_radians and its corresponding angle_in_degrees.

4. DEGREES() with a Variable

DECLARE @angle FLOAT;
SET @angle = PI()/3;
SELECT DEGREES(@angle) AS result;

This query uses a variable to store an angle in radians and then converts it to degrees. The result will be:

result
------
60

Full Example

Let's go through a complete example that includes creating a table, inserting data, and using the DEGREES() function.

Step 1: Creating a Table

This step involves creating a new table named example_table to store some sample data.

CREATE TABLE example_table (
    id INT PRIMARY KEY,
    angle_in_radians FLOAT
);

In this example, we create a table named example_table with columns for id and angle_in_radians.

Step 2: Inserting Data into the Table

This step involves inserting some sample data into the example_table.

INSERT INTO example_table (id, angle_in_radians) VALUES (1, PI());
INSERT INTO example_table (id, angle_in_radians) VALUES (2, PI()/2);
INSERT INTO example_table (id, angle_in_radians) VALUES (3, PI()/3);
INSERT INTO example_table (id, angle_in_radians) VALUES (4, PI()/4);

Here, we insert data into the example_table.

Step 3: Using the DEGREES() Function

This step involves using the DEGREES() function to convert the angle_in_radians column to degrees.

SELECT id, angle_in_radians, DEGREES(angle_in_radians) AS angle_in_degrees
FROM example_table;

This query retrieves the id, angle_in_radians, and the angle in degrees for each row in the example_table. The result will be:

id  angle_in_radians  angle_in_degrees
--- ----------------- -----------------
1   3.1415926536      180
2   1.5707963268      90
3   1.0471975512      60
4   0.7853981634      45

Conclusion

The SQL Server DEGREES() function is a powerful tool for converting an angle from radians to degrees. Understanding how to use the DEGREES() function and its syntax is essential for effective trigonometric calculations and data processing in SQL Server.