crackyourinterview.com


To improves our performance please Like Share Subscribe(Will boost us)

What are the 14 new functions in sql 2012
Question Posted on 28 Feb 2013Home >> DataBase >> sql questions >> What are the 14 new functions in sql 2012

Below are 14 new funtions added in sql 2012 which are categoriezed in 4 types as given below
(A)Conversion functions
   (1)PARSE
   (2)TRY_CONVERT
   (3)TRY_PARSE

(B)Date and Time functions
   (4)DATEFROMPARTS
   (5)DATETIME2FROMPARTS
   (6)DATETIMEFROMPARTS
   (7)DATETIMEOFFSETFROMPARTS
   (8)TIMEFROMPARTS
   (9)EOMONTH
   (10)SMALLDATETIMEFROMPARTS

(C)Logical functions
   (11)CHOOSE
   (12)IIF

(D)String functions
   (13)CONCAT
   (14)FORMAT
0
0



.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap