Adding new columns with SELECT

We can create new Columns with the SELECT clause. Simply use a C# expression and give it a column name with AS.

IMPORTANT: For the sake of brevity we will start omitting the EXTRACT and OUTPUT statements in the code samples.

@output = 
    SELECT 
        *, 
        (Query + Query) AS Query2
    FROM @searchlog;

In the example above, we added a column without having to explicitly list out all the other columns. Below you can see how we can add just specific columns.

@output = 
    SELECT 
        Region,
        Query, 
        (Query + Query) AS Query2, 
        Urls.Length AS UrlsLength
    FROM @searchlog;