SQL Server's CHOOSE Function

preview_player
Показать описание
In this episode we look at SQL Server's CHOOSE function and how using it compares to a table-based lookup.

Read the full post with examples:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. choose function
  5. array
Рекомендации по теме
Choose function in 0:05:32

Choose function in SQL Server

How to use 0:06:39

How to use the CHOOSE Function with SELECT | Essential SQL

CHOOSE() and IIF() 0:07:55

CHOOSE() and IIF() functions in SQL Server 2012

SQL Server Tutorials: 0:15:15

SQL Server Tutorials: 24. How to Use The CASE, IIF, and CHOOSE Functions

How do SQL 0:12:12

How do SQL Indexes Work

How To Backup 0:02:03

How To Backup A Database in Microsoft SQL Server (MSSQL) Management Studio [English 2020]

MOST usefull SQL 0:07:59

MOST usefull SQL Functions IIF function in sql choose,case statement in sql

5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

SQL Server Training 0:54:18

SQL Server Training From SQL School

09.How to Compare 0:04:32

09.How to Compare Two Databases of SQL Server using Visual studio

SQL 2019 Tutorials 0:09:57

SQL 2019 Tutorials | Sql Server editions | How to choose right edition of SQL Server

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

Choosing Between Views, 0:13:51

Choosing Between Views, Functions, and Stored Procedures in SQL With Examples

DateTime functions in 0:15:26

DateTime functions in SQL Server Part 25

What is Microsoft 0:01:52

What is Microsoft SQL Server?

SQL Ranking Functions: 0:08:51

SQL Ranking Functions: Part 1 The Over Clause

Cast and Convert 0:17:26

Cast and Convert functions in SQL Server Part 28

Logical Functions in 0:04:07

Logical Functions in SQL SERVER 2012 || CHOOSE and IIF functions in SQL Server 2012

RANK, DENSE_RANK, ROW_NUMBER 0:09:42

RANK, DENSE_RANK, ROW_NUMBER SQL Analytical Functions Simplified

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

Database vs Data 0:05:22

Database vs Data Warehouse vs Data Lake | What is the Difference?

How to restore 0:01:40

How to restore .bak file in SQL Server Management Studio 2019

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

IIF function in 0:04:00

IIF function in SQL Server

Комментарии
Автор

This is the sort of thing you see in obscure code that you didn't write that you're asked to support. It's not immediately obvious from the syntax what it does either. Great vid again!

harbor.boundary.flight
Автор

Bert, Wasn't aware of the Choose Function either. Great explanations and examples. Thank you !

sql
Автор

First off, thanks for all the great videos and content. I've recently started catching up on your full backlog and gotten a few others to start watching your stuff as well.

A few months ago I stumbled on a list of SQL Server functions like this that were added to make conversion from MS Access easier. One that I use a ton is "IIF", but a video of other syntactical sugar functions like IIF/NULLIF might be pretty interesting to a lot of people, like me. Thanks again for all the great content.

ChaosTheory
Автор

Seems like a lot of us didn't know about CHOOSE (in TSQL) - I use it a lot in Reporting Services, where we have dynamic content formatting (you can't create shared in-memory tables in SSRS, so we use CSV strings and parameters to achieve the same thing).

But useful to know, thanks for the vid... In that vein, maybe a few episodes re the other tech in the SQL stack (SSRS, SSAS, SSIS)?

Good luck with the flooded basement!!

Zanoni
Автор

Never seen this function before, thank you for sharing this!

Reitseschaatser
Автор

Just recently saw this function also. I thought it was cute but so far no need to use it in my daily developing. Great episode!

TheDroc