SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server 2012 Download and T-SQL Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




download SQL Server 2016
download SQL Server 2014



New T-SQL Functions in SQL Server 2012 for T-SQL Developers

Microsoft SQL Server 2012 introduces new functions for T-SQL developers with SQL Server Denali CTP3 version. These 14 new T-SQL built-in functions are part of T-SQL and programmability enhancements for developers in SQL Server 2012.

SQL Server 2011 or SQL11 are the names that are thought to be for the SQL Server Denali version. But Microsoft has named the new SQL Server version as SQL Server 2012 instead of SQL Server 2011.

Here is the list of new built-in Transact-SQL Functions in SQL Server 2012

T-SQL CONCAT string function
T-SQL FORMAT string function

T-SQL CHOOSE logical function
T-SQL IIF logical function

T-SQL DATEFROMPARTS date and time function
T-SQL DATETIMEFROMPARTS date and time function
T-SQL DATETIME2FROMPARTS date and time function
T-SQL DATETIMEOFFSETFROMPARTS date and time function
T-SQL SMALLDATETIMEFROMPARTS date and time function
T-SQL TIMEFROMPARTS date and time function
T-SQL EOMONTH date and time function

T-SQL PARSE conversion function
T-SQL TRY_CONVERT conversion function
T-SQL TRY_PARSE conversion function







SQL Server Resources

SQL Server Articles

SQL Server 2012

SQL Server Tools

SQL Blog

SQL Server 2008 Blog

Certification Exams Blog

Reporting Services Blog

Analysis Services Blog

MS SQL Server Forums



Free Exam Vouchers










Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems