SQL Server tutorial for beginners - Choose function in SQL Server

sql server choose function sql server 2012 choose function choose function in sql 2012 In this video we will discuss Choose function in SQL Server Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 Choose function Introduced in SQL Server 2012 Returns the item at the specified index from the list of available values The index position starts at 1 and NOT 0 (ZERO) Syntax : CHOOSE ( index, val_1, val_2, ... ) Example : Returns the item at index position 2 SELECT CHOOSE(2, 'India','US', 'UK') AS Country Example : Using CHOOSE() function with table data. We will use the following Employees table for this example. SQL Script to create Employees table Create table Employees ( Id int primary key identity, Name nvarchar(10), DateOfBirth date ) Go Insert into Employees values ('Mark', '01/11/1980') Insert into Employees values ('John', '12/12/1981') Insert into Employees values ('Amy', '11/21/1979') Insert into Employees values ('Ben', '05/14/1978') Insert into Employees values ('Sara', '03/17/1970') Insert into Employees values ('David', '04/05/1978') Go We want to display Month name along with employee Name and Date of Birth. Using CASE statement in SQL Server SELECT Name, DateOfBirth, CASE DATEPART(MM, DateOfBirth) WHEN 1 THEN 'JAN' WHEN 2 THEN 'FEB' WHEN 3 THEN 'MAR' WHEN 4 THEN 'APR' WHEN 5 THEN 'MAY' WHEN 6 THEN 'JUN' WHEN 7 THEN 'JUL' WHEN 8 THEN 'AUG' WHEN 9 THEN 'SEP' WHEN 10 THEN 'OCT' WHEN 11 THEN 'NOV' WHEN 12 THEN 'DEC' END AS [MONTH] FROM Employees Using CHOOSE function in SQL Server : The amount of code we have to write is lot less than using CASE statement. SELECT Name, DateOfBirth,CHOOSE(DATEPART(MM, DateOfBirth), 'JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP', 'OCT', 'NOV', 'DEC') AS [MONTH] FROM Employees Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/choose-function-in-sql-server.html