Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 15-12-2009
Member
 
Join Date: Jan 2009
Posts: 66
SQL Scalar Functions

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.
Reply With Quote
  #2  
Old 15-12-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: SQL Scalar Functions

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
Reply With Quote
  #3  
Old 15-12-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: SQL Scalar Functions

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
Reply With Quote
  #4  
Old 15-12-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: SQL Scalar Functions

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.
Reply With Quote
  #5  
Old 15-12-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: SQL Scalar Functions

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.
Reply With Quote
  #6  
Old 15-12-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: SQL Scalar Functions

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL Scalar Functions"
Thread Thread Starter Forum Replies Last Post
trim functions of VB Ram Bharose Software Development 5 31-12-2009 11:51 AM
How to call a C functions within PHP? Rixwel Software Development 3 05-09-2009 09:12 AM
PHP fsockopen Functions Japesh Software Development 3 22-05-2009 06:02 PM
Array Functions in PHP SuperXCM Software Development 2 26-03-2009 10:57 AM
Functions in PHP Gyan Guru Guides & Tutorials 3 13-12-2008 06:20 PM


All times are GMT +5.5. The time now is 07:14 AM.