SQL SERVER – New Functions in SQL Server 2012 – @SQLSERVER
We always need sophisticated function in any programming language. SQL Server does have lot of built-in functions that helps database developers.
In Denali CTP3, we have got new 14 built-in functions and 1 enhanced function. These functions have been categorized into.
14 new functions and 1 changed function in SQL Server Denali CTP3.
1) String functions
2) Logical functions
3) Conversion functions
4) Date and Time functions
- DATEFROMPARTS (Transact-SQL)
- DATETIME2FROMPARTS (Transact-SQL)
- DATETIMEFROMPARTS (Transact-SQL)
- DATETIMEOFFSETFROMPARTS (Transact-SQL)
- EOMONTH (Transact-SQL)
- SMALLDATETIMEFROMPARTS (Transact-SQL)
- TIMEFROMPARTS (Transact-SQL)
5) Math function – log function changed
Video demonstration (Watch and Learn)
Thanks for Watching and Reading.