Showing posts with label Trigonometry. Show all posts
Showing posts with label Trigonometry. Show all posts

Monday, 14 November 2016

SQL SERVER RADIANS FORMULA

SQL SERVER RADIANS FORMULA

-- EXAMPLE

SELECT RADIANS(PI()) AS [DISPLAY RADIANS OF PI VALUE RESULT];

SQL SERVER PI FORMULA

SQL SERVER PI FORMULA

-- EXAMPLE

SELECT PI() AS [DISPLAY PI FORMULA RESULT];

SQL SERVER LOGARITHM OF PI FORMULA

SQL SERVER LOGARITHM OF PI FORMULA

--THEORY

-- SELECT LOG(NUMERIC VALUE)AS [ALIAS NAME];

-- EXAMPLE

SELECT LOG(PI()) AS [LOG OF PI];

SQL SERVER LOG 10 OF PI FORMULA

SQL SERVER LOG 10 OF PI FORMULA

-- THEORY

-- SELECT LOG10([ENTER NUMERIC VALUE]) AS [ALIAS NAME OF FIELD VALUE];

-- EXAMPLE

SELECT LOG10(PI()) AS [LOG 10 OF PI];

SQL SERVER FUNCTION COT CO TANGENT

SQL SERVER FUNCTION COT CO TANGENT

--HI ALL, TODAY WE WILL LOOK AT THE COT CO TANGENT FUNCTION IS SQL SERVER SSMS

--FIRST WE START WITH THE KEYWORD, SELECT, THEN FOLLOWED BY THE FUNCTION NAME

--WE WANT TO USE FOLLOWED BY BRACKETS

SELECT COT(180);

--THEN HIGHLIGHT THE CODE AND CLICK ON EXECUTE OR (F5)

--AS YOU CAN SEE THE ANSWER TO WHAT IS THE CO TANGENT OF 180 IS 0.75

--THAT IS IT

SQL SERVER FUNCTION COS COSINE

SQL SERVER FUNCTION COS COSINE

--Hi all we will now look at the COS or cosine function using SQL SERVER SSMS

--first start with the select keyword, then type the function name.
select COS(180);

--then higlight the specific code and click on run
--that is it.

SQL SERVER ATN2 TRIGONOMETRY FORMULA

SQL SERVER ATN2 TRIGONOMETRY FORMULA

--alright viewers, we will look at the ATN2 function which returns a float value for 2 varying floats

--let us begin

--firstly, to enable intellisense so the predictive text appears on the screen to do with functions, fields, and

--expressions you need to click the button above

--we are using SQL SERVER 2012 IN SSMS

--or instead of double clicking to get the popup of the function after the select clause just start typing the function name

--with trig functions it is good practice and almost always prerequisite to use radians for your values

--to execute press (F5) or click on the !Execute button

-- the float value result is 0.32175 for the radians of 90 and 180.

--that is it.

select ATN2(radians(90),radians(180));