CHAPTER

4

SQL Components

In This Chapter

•   SQL’s Basic Objects

•   Data Types

•   Transact-SQL Functions

•   Scalar Operators

•   NULL Values

This chapter introduces the elementary objects and basic operators supported by the Transact-SQL language. First, the basic language elements, including constants, identifiers, and delimiters, are described. Then, because every elementary object has a corresponding data type, data types are discussed in detail. Additionally, all existing operators and functions are explained. At the end of the chapter, NULL values are introduced.

SQL’s Basic Objects

The language of the Database Engine, Transact-SQL, has the same basic features as other common programming languages:

•   Literal values (also called ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial