SQL – Datatype Functions The Data Type functions in SQL are a scalar functions that returns information about various data type values. Following are the SQL date type functions − Sr.No. Function & Description 1 Returns the number of bytes used to represent any expression and also counts the leading and trailing spaces of the […]

SQL – Conversion Functions In SQL, the conversion functions are used to convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The first datatype is the input datatype. The second datatype is the output datatype. List of Functions Following is a list of […]

SQL – JSON Functions JSON (JavaScript Object Notation) is a simple format for exchanging data. It is self-descriptive, understandable in any language, and irrespective of language. It serves as an XML substitute. JSON is currently a popular data transfer standard. The data that returned by modern services is JSON text. SQL Server JSON is the […]