New features in SQL Server 2012 - SQL 2012 training

https://sqlserver2014tutorial.com/ In this video training we cover new features in SQL Server 2012 from TSQL point of view. We start New Transact SQL features in 2012 with Sequence. A Sequence object provides functionality similar to Identity, we show you create sequence idsequence. Next we go over DATEFROMPARTS, TIMEFROMPARTS and EOMONTH Functions. The OFFSET clause in TSQL is discussed with Northwind database. New Logical functions Select choose and select inline iif are demonstrated. Raiserror SQL is compared with THROW SQL statement. SELECT CONCAT function in SQL 2012 training and Using FORMAT command with SELECT GETDATE() is shown. Finally PARSE() function is discussed. Visit our other sites: https://www.learningcomputer.com https://datatechnologyllc.com https://sqlserver2014tutorial.com/