SQL Scalar Functions

[Bhardwaj]

Hi, I want to know the details about the scalar functions in SQL. If anyone is having more information about this, then please help me to get that. I want to know the details about it so that it will be helpful to me. Please reply me if anyone is having details about it.

[Katty]

Hi, I know some of the scalar functions as below:

• UCASE() - This converts a field string to upper case
• LCASE() - This converts a field string to lower case
• MID() - It simply extract characters from a text field
• LEN() - It returns the length of a text field
• ROUND() - It rounds a numeric field to the number of decimals specified
• NOW() - It returns the current system date and time
• FORMAT() - It formats regarding field while displaying

[Reegan]

I have the knowledge about the following functions in SQL which are comes under the category of scalar. They are as follows:

• Scalar Numeric Functions

1. Multiplication
2. Division
3. Addition
4. Subtraction

• SQL Scalar Character String Functions

1. CONCATENATION
2. SUBSTRING
3. CHARACTER_LENGTH
4. POSITION
5. TRIM
6. UPPER and LOWER

• SQL Scalar Date/Time Functions

1. CURRENT_DATE
2. CURRENT_TIME
3. CURRENT_TIMESTAMP
4. EXTRACT

• SQL Scalar CAST Function
• SQL Scalar Routine Invocation
• Routine Determination

[kelfro]

I am not having any knowledge about the SQL but, you can make use of different books to get the more information about the functions from the SQL. So, you can get the books such as Complete Reference: SQL and get more knowledge about it. So, just get the book and then use it to improve your knowledge. You can search this book on internet to solve your problem. So, use it.

[Zecho]

Sql has the following Scalar Functions category:

• Configuration Functions : This function returns information about the current configuration.
• Cursor Functions : This scalar function return information about cursors.
• Date and Time : This scalar function perform operations on a date and time input values
• Mathematical Functions : Contains numerical calculations
• Metadata Functions : It return information about the database and database objects.
• Security Functions : It gives information about users and roles.
• String Functions : Perform operations on a string
• System Functions : Gives information about the SQL Server
• System Statistical Functions : It gives statistical information about the system.

[MindSpace]

Hey, I am also searching for the same thing. I have to create a casestudy on the SCALAR Functions from SQL, but I am having only names of those scalar functions. So, if you are having more information about it, then please give me that to improve my casestudy. I am not able to get more information about it. So, if you provide any book or any type link from which I can able to get more information.