Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Introduction
3. The Slogan table
Concatenation
Simple text functions
How to modify Strings
Summary

Instruction

Finally, let's look at the third table.

Exercise

Select all columns from the Slogan table. For each record, we have:

  • an identifier (the Id column),
  • a reference to the related item (the ItemId column),
  • the best medium for the slogan (e.g. TV, Internet, or radio—the Type column),
  • the slogan itself (the Text column),
  • and the Id of the copywriter who wrote that slogan (the CopywriterId column).