hypanis.ru Transact SQL Archives - BuffaloBI.com

SQL CHOOSE Logical Function

The SQL CHOOSE Logical Function returns the item at the specified index from a list of values in SQL Server.  I’ve used it sporadically, but it equates to a work around for the CASE statement, making the query a bit more readable in some instances.  Let’s get to a couple examples. SQL CHOOSE Logical Function … Read more

SQL IN Logical Operator

The following post provides a few simple examples on how to utilize the SQL IN Logical Operator when executing T-SQL statements.  There are several techniques that make this a very useful statement in the WHERE clause. From the Microsoft Documentation site:  Logical operators test for the truth of some condition. Logical operators, like comparison operators, … Read more


The following post illustrates how to use the SQL UNION and SQL UNION ALL Operators. From time to time, I need to bring content from two separate tables together in a query.  Using the SQL UNION or SQL UNION ALL operators, I can combine this information using two SELECT statements, bringing the results together. SQL … Read more