Post has shared content
We are already familiar with DATEDIFF function introduced in the very initial version of SQL Server. But, in SQL Server 2016, Microsoft has introduced DATEDIFF_BIG function which can be used to compute the difference between two given dates in terms of the given date part. In this post, we are going to explore the use of the DATEDIFF_BIG function.

http://www.sqlrelease.com/datediff-and-datediff_big-sql-server-2016

#datediff_big

Post has shared content
In this post, we will see that how we can skip levels in XML string to read all the elements at a given level regardless of the level name.

Please share this post if you like this.
#sqlrelease #xml #sql

http://www.sqlrelease.com/select-all-elements-regardless-of-level-in-xml

Post has shared content
Hi Friends,

I am happy to share that we have started our first video tutorial series "Unfolding | Set Based Approach" on YouTube channel and at SQLRelease.com.

In this series, we will learn how to break down the RBAR(row by agonizing row, or row by row) problems using set based manner.
This course is not based on how to write queries, rather it is based on how to think in set based manner.

Here is the link of the YouTube channel:
https://www.youtube.com/channel/UCF4IvmVUzd7to5L87nn9fhw

Please subscribe to my channel and share these videos if you like them.
Hi Friends,

I am happy to share that we have started our first video tutorial series "Unfolding | Set Based Approach" on YouTube channel and at SQLRelease.com.

In this series, we will learn how to break down the RBAR(row by agonizing row, or row by row) problems using set based manner.
This course is not based on how to write queries, rather it is based on how to think in set based manner.

Here is the link of the YouTube channel:
https://www.youtube.com/channel/UCF4IvmVUzd7to5L87nn9fhw

Please subscribe to my channel and share these videos if you like them.

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded