{"id":511,"date":"2017-07-27T09:04:19","date_gmt":"2017-07-27T13:04:19","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=511"},"modified":"2021-09-16T14:58:06","modified_gmt":"2021-09-16T18:58:06","slug":"database-administration-fundamentals-ws17sql1007-day-10","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=511","title":{"rendered":"Database Administration Fundamentals (WS17SQL1007) &#8211; Day 10"},"content":{"rendered":"<p>We have finished our five-week adventure into the land of SQL (<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?cat=19\" target=\"_blank\" title=\"WS17SQL1007\" rel=\"noopener\">WS17SQL1007<\/a>). Thank you for joining us.<\/p>\n<p>By the way, try to figure out what the following prints. You might not need to go to <a>http: \/\/ascii.cl\/<\/a>.<\/p>\n<pre>DECLARE @yourNAME VARCHAR(50),\r\n        @yourCRSE VARCHAR(11);\r\n\r\nSET @yourNAME = '#space_holder_for_your_name#';\r\n                                -- your name in this param\r\nSET @yourCRSE = 'WS17SQL1007';  -- this class ending today\r\n\r\nPRINT   CHAR(84) +CHAR(104)+CHAR(97) +CHAR(110)+CHAR(107)+\r\n        CHAR(32) +CHAR(121)+CHAR(111)+CHAR(117)+CHAR(44) +\r\n        CHAR(32) +@yourNAME+CHAR(44) +CHAR(32) +CHAR(102)+\r\n        CHAR(111)+CHAR(114)+CHAR(32) +CHAR(116)+CHAR(97) +\r\n        CHAR(107)+CHAR(105)+CHAR(110)+CHAR(103)+CHAR(32) +\r\n        CHAR(99) +CHAR(108)+CHAR(97) +CHAR(115)+CHAR(115)+\r\n        CHAR(32) +@yourCRSE+CHAR(46) +CHAR(13) +CHAR(83) +\r\n        CHAR(101)+CHAR(101)+CHAR(32) +CHAR(121)+CHAR(111)+\r\n        CHAR(117)+CHAR(32) +CHAR(105)+CHAR(110)+CHAR(32) +\r\n        CHAR(116)+CHAR(104)+CHAR(101)+CHAR(32) +CHAR(105)+\r\n        CHAR(110)+CHAR(116)+CHAR(101)+CHAR(114)+CHAR(109)+\r\n        CHAR(101)+CHAR(100)+CHAR(105)+CHAR(97) +CHAR(116)+\r\n        CHAR(101)+CHAR(32) +CHAR(99) +CHAR(108)+CHAR(97) +\r\n        CHAR(115)+CHAR(115)+CHAR(46) +CHAR(13) +CHAR(13) +\r\n        CHAR(70) +CHAR(46) +CHAR(79) +CHAR(108)+CHAR(118)+\r\n        CHAR(101)+CHAR(114)+CHAR(97) +CHAR(13) +CHAR(102)+\r\n        CHAR(111)+CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+\r\n        CHAR(97) +CHAR(64) +CHAR(98) +CHAR(109)+CHAR(99) +\r\n        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+\r\n        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+\r\n        CHAR(13) +CHAR(104)+CHAR(116)+CHAR(116)+CHAR(112)+\r\n        CHAR(58) +CHAR(47) +CHAR(47) +CHAR(102)+CHAR(111)+\r\n        CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+CHAR(97) +\r\n        CHAR(46) +CHAR(99) +CHAR(111)+CHAR(109)+CHAR(109)+\r\n        CHAR(111)+CHAR(110)+CHAR(115)+CHAR(46) +CHAR(103)+\r\n        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+\r\n        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+\r\n        CHAR(47) ;          -- calling characters in ASCII<\/pre>\n<p>Download the <a title=\"Class Notes for WS17SQL1007 - Day 10 (2017\/07\/26)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2017\/07\/WS17SQL1007.20170726.pdf\">class notes<\/a> for day 10.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 = &#8216;#space_holder_for_your_name#&#8217;; &#8212; your name in this param SET @yourCRSE = [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[19,3,1,17,2],"tags":[],"class_list":["post-511","post","type-post","status-publish","format-standard","hentry","category-ws17sql1007","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=511"}],"version-history":[{"count":7,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/511\/revisions"}],"predecessor-version":[{"id":946,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/511\/revisions\/946"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}