Conventions

In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: " One table has varchar(5) columns, which will be small enough to fit in the in-row storage."

A block of code is set as follows:

EXEC dbo.InsertSimpleOrder
@OrderId = 5, @OrderDate = '20160702', @Customer = N'CustA';
EXEC dbo.InsertSimpleOrderDetail
@OrderId = 5, @ProductId = 1, @Quantity = 50;

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

ProductId INT NOT NULL CONSTRAINT PK_Product PRIMARY KEY, 
   ProductName NVARCHAR(50) NOT NULL, 
   Price MONEY NOT NULL, 
   ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL, 
   ValidTo DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL, 
   PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)

Any command-line input or output is written as follows:

SQL Server Execution Times:
CPU time = 1797 ms, elapsed time = 1821 ms.

New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this:

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.