Experimenting with CHOOSE: #SQLNewBlogger
I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included. I decided to test.
This post looks at the tests and results.
Tl;dr It appears 3925 is the most arguments.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Building a Script
Since I want to know where things fail, I decided to make a short T-SQL script that tests increasing numbers of parameters. This script builds a dynamic CHOOSE() select using a…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.