Boolean Values and Logical Operations in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on Boolean Values and Logical Operations in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Boolean Values and Logical Operations in SQL Server Transact-SQL. Clear answers are provided with tutorial exercises on getting Boolean values with comparison operations; CASE expressions; BETWEEN and IN comparisons; pattern match with LIKE operator; EXISTS and IN subquery expressions; AND and OR logical operations.

What Is a Boolean Value in SQL Server

CASE - Conditional Expressions in SQL Server

What Are Comparison Operations in SQL Server

Performing Comparison on Exact Numbers in SQL Server

Performing Comparison on Floating Point Numbers in SQL Server

Performing Comparison on Date and Time Values in SQL Server

Performing Comparison on Character Strings in SQL Server

BETWEEN - Testing Value in a Range in SQL Server

IN - Testing Value in a Value List in SQL Server

LIKE - Matching a Pattern in a Character String in SQL Server

Using Wildcard Characters in LIKE Operations in SQL Server

EXISTS - Testing Subquery Results in SQL Server

IN - Testing Values Returned by a Subquery in SQL Server

What Are Logical/Boolean Operations in SQL Server

⇒ What Is a Boolean Value in SQL Server

⇐ NULLIF() - Replacing Given Values with NULL in SQL Server

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-29, 3147🔥, 0💬