Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

Functions

Chapter 13:

SQL Predefined Functions:
  1. Numeric functions
  2. Date function
  3. String functions

Numeric Functions:

Absolute: The ABS() function returns the absolute value of a number.

Average: The AVG() function returns the average value of an expression.



Count: The COUNT() function returns the number of records returned by a select query.


Max: The MAX() function returns the maximum value in a set of values.


Min: The MIN() function returns the minimum value in a set of values.



Sum: The SUM() function calculates the sum of a set of values.



Round: The Round() function rounds a number to a specified number of decimal places.



Square: The Square() function returns the square of a number.



SquareRoot: The SQRT() function returns the square root of a number.



Power: The POWER() function returns the value of a number raised to the power of another number.



PI: The PI() function returns the value of PI.



CEILING: The CEILING() function returns the smallest integer value that is larger than or equal to a number.



Floor: The FLOOR() function returns the largest integer value that is smaller than or equal to a number.





Date Function:

 Current Timestamp: The CURRENT_TIMESTAMP() function returns the current date and time, in  a 'YYYY-MM-DD hh:mm:ss:mmm' format.


DATEADD: The DATEADD() function adds a time/date interval to a date and then returns the date.


DATEDIFF: The DATEDIFF() function returns the difference between two dates.


DATEFROMPARTS: The DATEFROMPARTS() function returns a date from the specified parts(year, month and day values).


DATENAME: The DATENAME() function returns a specified part of a date.



DATEPART: The DATEPART() function returns a specified part of a date.



DAY: The DAY() function returns the day of the month for a specified date.



GETDATE: The GETDATE() function returns the current database system date and time, in a 'YYYY-MM-DD hh:mm:ss:mmm' format.



GETUTCDATE: The GETUTCDATE() function returns the current database system UTC date and time, in a 'YYYY-MM-DD hh:mm:ss:mmm' format.



ISDATE: The ISDATE() function checks an expression and returns 1 if it is a valid date, otherwise 0.





MONTH: The MONTH() function returns the month part for a specified date( a number from 1 to 12).



SYSDATETIME: The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.



YEAR: The YEAR() function returns the year part of a specified date.





String Function:




Subscribe to: Posts (Atom)