TSQL

I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …

  CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …

  SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …

  The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …

  The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …

  EXP Functions calculates the exponential value of a parameter that has the float data type. This function’s return data type is float. Below you …

  The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number …

The ABS function returns the positive value of a negative number. The return data type is the data type of the input parameter. The ABS …

If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State …

The importance of JSON data type in our lives continues to increase day by day. We will examine the functions that SQL Server provides us …