Database Administration Fundamentals (WS17SQL1007) – Day 10

We have finished our five-week adventure into the land of SQL (WS17SQL1007). Thank you for joining us.

By the way, try to figure out what the following prints. You might not need to go to http: //ascii.cl/.

DECLARE @yourNAME VARCHAR(50),
        @yourCRSE VARCHAR(11);

SET @yourNAME = '#space_holder_for_your_name#';
                                -- your name in this param
SET @yourCRSE = 'WS17SQL1007';  -- this class ending today

PRINT   CHAR(84) +CHAR(104)+CHAR(97) +CHAR(110)+CHAR(107)+
        CHAR(32) +CHAR(121)+CHAR(111)+CHAR(117)+CHAR(44) +
        CHAR(32) +@yourNAME+CHAR(44) +CHAR(32) +CHAR(102)+
        CHAR(111)+CHAR(114)+CHAR(32) +CHAR(116)+CHAR(97) +
        CHAR(107)+CHAR(105)+CHAR(110)+CHAR(103)+CHAR(32) +
        CHAR(99) +CHAR(108)+CHAR(97) +CHAR(115)+CHAR(115)+
        CHAR(32) +@yourCRSE+CHAR(46) +CHAR(13) +CHAR(83) +
        CHAR(101)+CHAR(101)+CHAR(32) +CHAR(121)+CHAR(111)+
        CHAR(117)+CHAR(32) +CHAR(105)+CHAR(110)+CHAR(32) +
        CHAR(116)+CHAR(104)+CHAR(101)+CHAR(32) +CHAR(105)+
        CHAR(110)+CHAR(116)+CHAR(101)+CHAR(114)+CHAR(109)+
        CHAR(101)+CHAR(100)+CHAR(105)+CHAR(97) +CHAR(116)+
        CHAR(101)+CHAR(32) +CHAR(99) +CHAR(108)+CHAR(97) +
        CHAR(115)+CHAR(115)+CHAR(46) +CHAR(13) +CHAR(13) +
        CHAR(70) +CHAR(46) +CHAR(79) +CHAR(108)+CHAR(118)+
        CHAR(101)+CHAR(114)+CHAR(97) +CHAR(13) +CHAR(102)+
        CHAR(111)+CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+
        CHAR(97) +CHAR(64) +CHAR(98) +CHAR(109)+CHAR(99) +
        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+
        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+
        CHAR(13) +CHAR(104)+CHAR(116)+CHAR(116)+CHAR(112)+
        CHAR(58) +CHAR(47) +CHAR(47) +CHAR(102)+CHAR(111)+
        CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+CHAR(97) +
        CHAR(46) +CHAR(99) +CHAR(111)+CHAR(109)+CHAR(109)+
        CHAR(111)+CHAR(110)+CHAR(115)+CHAR(46) +CHAR(103)+
        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+
        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+
        CHAR(47) ;          -- calling characters in ASCII

Download the class notes for day 10.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.