Learn T-SQL Querying

Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, path names, dummy URLs, user input, and Twitter handles. Here is an example: "For example, if our table contains 1,000,000 rows, the calculation is SQRT(1000 * 1000000) = 31622."

A block of code is set as follows:

SELECT NationalIDNumber, JobTitle, MaritalStatusINTO HumanResources.Employee2FROM HumanResources.Employee;

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

[default]exten => s,1,Dial(Zap/1|30)exten => s,2,Voicemail(u100)exten => s,102,Voicemail(b100)exten => i,1,Voicemail(s0) ...