Sql Server 2012- Date time new function
Alok Singh
22:38
Sql Server 2012- Date time new function Following are the seven new date time functions have been introduced in SQL Server 2012 1:- DAT...
Monday, 24 October 2016
How to Use LAST_VALUE() SQL function
Alok Singh
02:55
LAST_VALUE() Function LAST_VALUE () function is introduced in SQL Server 2012. LAST_VALUE() returns first value from the list. Syntax :...
How to Use FIRST_VALUE() SQL function
Alok Singh
02:50
FIRST_VALUE() function FIRST_VALUE () function is introduced in SQL Server 2012. FIRST_VALUE() returns first value from the list. Synt...
How to Use TRY_CONVERT SQL Function
Alok Singh
02:09
TRY_CONVERT() Function The TRY_CONVERT works like the CONVERT function. TRY_CONVERT function returns a NULL instead of generating an erro...
How to Use TRY_CAST() SQL function
Alok Singh
02:06
TRY_CAST() function TRY_CAST () function is introduced in SQL Server 2012. it is used to cast input string to the specified data type. i...
How to Use TRY_PARSE() SQL function
Alok Singh
02:03
TRY_PARSE() function TRY_PARSE () function is introduced in SQL Server 2012. it convert any string value to Date/Time format or Numeric ....
How to Use CHOOSE SQL function
Alok Singh
01:39
CHOOSE() function CHOOSE() function is used to get the value of a list by its index number. it acts like an index into an array. The In...
How to Use IIF SQL Function
Alok Singh
01:34
IIF SQL Function IIF () is built-in logical function and introduced in Sql Server 2012. It is similar to CASE and IF statements in SQL ...
Tuesday, 18 October 2016
3 Top Difference between Sequence and Identity
Alok Singh
21:45
Identity and Sequence both are used to generate auto-incrementing numbers. following are the differences:- Sequence is independent from...
How to Use "WITH RESULT SETS" Feature of SQL Server 2012
Alok Singh
05:28
WITH RESULT SETS: - WITH RESULT SETS can be used to change the output of stored procedures by defining new column names, their type, ...
How to Use "OFFSET and FETCH" Feature of SQL Server 2012
Alok Singh
04:57
OFFSET and FETCH is introduced in SQL Server 2012. Most popular uses for OFFSET and FETCH is paging OFFSET The OFFSET is used to s...
Monday, 17 October 2016
Best Explanation of Sequences in SQL Server
Alok Singh
23:39
Sequences Sequence is introduced in SQL Server 2012. Sequence is a user-defined object that creates a sequence of a number. It is simil...
Friday, 7 October 2016
Sql Server - Date and Time function - EOMONTH()
Alok Singh
02:33
EOMONTH ():- This is new date time function that is introduced in SQL server 2012. This function can be used to get the last day of the m...
