Integers

Unpack an Integer with SQL Server Recursion

  • Article

Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.

2013-04-26

3,186 reads

Blogs

Speaking at DataMinds Connect 2020

By

I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one...

SQLSaturday Auckland: Certification Exams Inside Out this Weekend!

By

Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting...

Data Cleanup for WordPress Tags without a Plugin

By

Over the years I’ve had this blog, I’ve added lots of tags. In 15...

Read the latest Blogs

Forums

Operating system error 1117 (I/O device error)

By Anderso

Hi, I have 3 Hyper-V servers in  a cluster with a SQL2019 VM on...

how to add a second file share witness?

By snomadj

Morning all,   Within failover cluster manager, how do add a 2nd file share...

SELECT Statement BLocking

By VastSQL

Hi Experts, we have observed that the SELECT statements are causing from application which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers