SQL

Database Administration Fundamentals (SF18SQL10001) – Day 3

Francisco Olvera

So far, we have covered the two ways you can concatenate strings (using function `CONCAT()` or using the `+` sign). We understand that using the `+` sign has limitations. When adding a string to a NULL, your result is a NULL. To avoid the latter, we can use a `CASE` clause.

  CASE
    WHEN   condition1
      THEN action1
    WHEN   condition2
      THEN action2
    ELSE   escape_action
  END

Download the class notes for day 3.

Database Administration Fundamentals (SF1801) – Day 10

Francisco Olvera

Download the class notes for day 10 — the answer for the final.

  DECLARE @yourName VARCHAR(50) = 'your_name';
  DECLARE @CourseCd VARCHAR(15) = 'SF1801';
  PRINT CONCAT (
      CHAR(084),CHAR(104),CHAR(097),CHAR(110),CHAR(107),CHAR(032),
      CHAR(121),CHAR(111),CHAR(117),CHAR(044),CHAR(032),@yourName,
      CHAR(044),CHAR(032),CHAR(102),CHAR(111),CHAR(114),CHAR(032),
      CHAR(116),CHAR(097),CHAR(107),CHAR(105),CHAR(110),CHAR(103),
      CHAR(032),CHAR(099),CHAR(108),CHAR(097),CHAR(115),CHAR(115),
      CHAR(032),@CourseCd,CHAR(046),CHAR(013),CHAR(083),CHAR(101),
      CHAR(101),CHAR(032),CHAR(121),CHAR(111),CHAR(117),CHAR(032),
      CHAR(105),CHAR(110),CHAR(032),CHAR(116),CHAR(104),CHAR(101),
      CHAR(032),CHAR(105),CHAR(110),CHAR(116),CHAR(101),CHAR(114),
      CHAR(109),CHAR(101),CHAR(100),CHAR(105),CHAR(097),CHAR(116),
      CHAR(101),CHAR(032),CHAR(099),CHAR(108),CHAR(097),CHAR(115),
      CHAR(115),CHAR(046),CHAR(013),CHAR(013),CHAR(070),CHAR(046),
      CHAR(079),CHAR(108),CHAR(118),CHAR(101),CHAR(114),CHAR(097),
      CHAR(013),CHAR(102),CHAR(111),CHAR(108),CHAR(118),CHAR(101),
      CHAR(114),CHAR(097),CHAR(064),CHAR(098),CHAR(109),CHAR(099),
      CHAR(099),CHAR(046),CHAR(099),CHAR(117),CHAR(110),CHAR(121),
      CHAR(046),CHAR(101),CHAR(100),CHAR(117),CHAR(013),CHAR(104),
      CHAR(116),CHAR(116),CHAR(112),CHAR(058),CHAR(047),CHAR(047),
      CHAR(102),CHAR(111),CHAR(108),CHAR(118),CHAR(101),CHAR(114),
      CHAR(097),CHAR(046),CHAR(099),CHAR(111),CHAR(109),CHAR(109),
      CHAR(111),CHAR(110),CHAR(115),CHAR(046),CHAR(103),CHAR(099),
      CHAR(046),CHAR(099),CHAR(117),CHAR(110),CHAR(121),CHAR(046),
      CHAR(101),CHAR(100),CHAR(117),CHAR(047)
      );