AppDividend
Latest Code Tutorials
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 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…