Browsing Category
SQL
SQL is a standard language for storing, manipulating and retrieving data in databases.
Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.
SQL CAST Function Example
SQL CAST is an inbuilt function that is used for converting an expression from one data type to another data type. Here, if the conversion takes place, then a value with specified conversion will be returned. Otherwise, the function will…
SQL CURRENT_USER Function Example
SQL CURRENT_USER is an inbuilt function that is used for returning the name of the current user in the SQL SERVER database. SQL CURRENT_USER function returns the name of the current user in the SQL Server database. SQL CURRENT_USER SQL…
SQL USER_NAME Function Example
SQL USER_NAME is an inbuilt function that is used for returning the name of the user working currently in the SQL SERVER database by providing an identification number to the function. SQL USER_NAME returns the database user name (will…
SQL SESSION_USER Function Example
SQL SESSION_USER is an inbuilt function that is used for returning the name of the user working currently in the SQL SERVER database. SQL SESSION_USER returns the user name of the current context in the current database. SQL SESSION_USER…
SQL SYSTEM_USER() Function Example
SQL SYSTEM_USER() is an inbuilt function that is used for returning the login information for the current user in the SQL SERVER or MySQL database. It returns the login name information for the current user. For the MySQL database, The…
SQL ATN2() Function Example | ATN2() in SQL
SQL ATN2() is an inbuilt function that is used for finding the arctangent of two number i.e. it returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values or…
SQL ATAN() Function Example | atan() in SQL
SQL ATAN() is an inbuilt function that is used for finding the arctangent of a number, i.e., it returns angle, in radians, whose tangent is a specified float expression. The SQL ATAN() function returns the arctangent of a value. In other…
SQL ASIN() Function Example | ASIN() in SQL
SQL ASIN() is an inbuilt function that is used for finding the arc sine of a number. The number should be in the range of -1 to 1; otherwise, it will return NULL. SQL ASIN() SQL ASIN() function returns the arc sine of a number. The…
SQL ACOS Function Example | acos() in SQL
SQL ACOS() is an inbuilt function that is used for finding the arc cosine of a number. The number should be in the range of -1 to 1; otherwise, it will return NULL. SQL COS() SQL ACOS() function returns the arccosine of a number. In…
SQL ABS() Function Example | ABS() in SQL
SQL ABS() is an inbuilt function that is used for returning the absolute value of a number when passed as an argument, i.e., the negative number gets converted to an absolute positive number. SQL ABS() SQL ABS() method is used to get…
SQL SYSDATETIMEOFFSET() Function Example
SQL SYSDATETIMEOFFSET() is an inbuilt function that returns a value that represents the current system date and time, which also includes the time zone, of the computer on which the SQL Server instance is running. The datatype returned is…
