{"id":1245,"date":"2023-05-05T11:24:03","date_gmt":"2023-05-05T15:24:03","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1245"},"modified":"2023-05-05T11:24:03","modified_gmt":"2023-05-05T15:24:03","slug":"introduction-to-structured-query-language-for-data-analytics-ws23sql1001-day-10","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1245","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (WS23SQL1001) \u2014 Day 10"},"content":{"rendered":"

It has been great experience teaching this class and I hope you had fun — aside from learning SQL, of course.<\/p>\n

    CREATE PROCEDURE<\/span> final.message_sp\r\n    AS\r\n    BEGIN\r\n      DECLARE<\/span> @yourName VARCHAR<\/span><\/span>(50) = 'your_name'<\/span>,   -- param to hold your name<\/span>\r\n              @CourseCd VARCHAR<\/span><\/span>(15) = 'WS23SQL1001'<\/span>; -- code for the SQL course<\/span>\r\n      PRINT<\/span> CONCAT<\/span> ( CHAR<\/span><\/span>(084), CHAR<\/span>(104), CHAR<\/span>(097), CHAR<\/span>(110), CHAR<\/span>(107),\r\n          CHAR<\/span>(032), CHAR<\/span>(121), CHAR<\/span>(111), CHAR<\/span>(117), CHAR<\/span>(044), CHAR<\/span>(032),\r\n          @yourName, CHAR<\/span>(044), CHAR<\/span>(032), CHAR<\/span>(102), CHAR<\/span>(111), CHAR<\/span>(114),\r\n          CHAR<\/span>(032), CHAR<\/span>(116), CHAR<\/span>(097), CHAR<\/span>(107), CHAR<\/span>(105), CHAR<\/span>(110),\r\n          CHAR<\/span>(103), CHAR<\/span>(032), CHAR<\/span>(099), CHAR<\/span>(108), CHAR<\/span>(097), CHAR<\/span>(115),\r\n          CHAR<\/span>(115), CHAR<\/span>(032), @CourseCd, CHAR<\/span>(046), CHAR<\/span>(013), CHAR<\/span>(083),\r\n          CHAR<\/span>(101), CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(121), CHAR<\/span>(111), CHAR<\/span>(117),\r\n          CHAR<\/span>(032), CHAR<\/span>(105), CHAR<\/span>(110), CHAR<\/span>(032), CHAR<\/span>(116), CHAR<\/span>(104),\r\n          CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(105), CHAR<\/span>(110), CHAR<\/span>(116), CHAR<\/span>(101),\r\n          CHAR<\/span>(114), CHAR<\/span>(109), CHAR<\/span>(101), CHAR<\/span>(100), CHAR<\/span>(105), CHAR<\/span>(097),\r\n          CHAR<\/span>(116), CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(099), CHAR<\/span>(108), CHAR<\/span>(097),\r\n          CHAR<\/span>(115), CHAR<\/span>(115), CHAR<\/span>(046), CHAR<\/span>(013), CHAR<\/span>(013), CHAR<\/span>(070),\r\n          CHAR<\/span>(046), CHAR<\/span>(079), CHAR<\/span>(108), CHAR<\/span>(118), CHAR<\/span>(101), CHAR<\/span>(114),\r\n          CHAR<\/span>(097), CHAR<\/span>(032), CHAR<\/span>(040), CHAR<\/span>(102), CHAR<\/span>(111), CHAR<\/span>(108),\r\n          CHAR<\/span>(118), CHAR<\/span>(101), CHAR<\/span>(114), CHAR<\/span>(097), CHAR<\/span>(064), CHAR<\/span>(098),\r\n          CHAR<\/span>(109), CHAR<\/span>(099), CHAR<\/span>(099), CHAR<\/span>(046), CHAR<\/span>(099), CHAR<\/span>(117),\r\n          CHAR<\/span>(110), CHAR<\/span>(121), CHAR<\/span>(046), CHAR<\/span>(101), CHAR<\/span>(100), CHAR<\/span>(117),\r\n          CHAR<\/span>(041), CHAR<\/span>(013), CHAR<\/span>(104), CHAR<\/span>(116), CHAR<\/span>(116), CHAR<\/span>(112),\r\n          CHAR<\/span>(058), CHAR<\/span>(047), CHAR<\/span>(047), CHAR<\/span>(102), CHAR<\/span>(111), CHAR<\/span>(108),\r\n          CHAR<\/span>(118), CHAR<\/span>(101), CHAR<\/span>(114), CHAR<\/span>(097), CHAR<\/span>(046), CHAR<\/span>(099),\r\n          CHAR<\/span>(111), CHAR<\/span>(109), CHAR<\/span>(109), CHAR<\/span>(111), CHAR<\/span>(110), CHAR<\/span>(115),\r\n          CHAR<\/span>(046), CHAR<\/span>(103), CHAR<\/span>(099), CHAR<\/span>(046), CHAR<\/span>(099), CHAR<\/span>(117),\r\n          CHAR<\/span>(110), CHAR<\/span>(121), CHAR<\/span>(046), CHAR<\/span>(101), CHAR<\/span>(100), CHAR<\/span>(117),\r\n          CHAR<\/span>(047) );\r\n    END<\/span>;\r\n\r\n    EXECUTE<\/span> final.message_sp;\r\n<\/strong><\/pre>\n
Download the class notes<\/a> for day 10.<\/p>\n","protected":false},"excerpt":{"rendered":"
It has been great experience teaching this class and I hope you had fun — aside from learning SQL, of course. CREATE PROCEDURE final.message_sp AS BEGIN DECLARE @yourName VARCHAR(50) = ‘your_name’, — param to hold your name @CourseCd VARCHAR(15) = ‘WS23SQL1001’; — code for the SQL course PRINT CONCAT ( CHAR(084), CHAR(104), CHAR(097), CHAR(110), CHAR(107), […]<\/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":[33,3,1,2],"tags":[],"class_list":["post-1245","post","type-post","status-publish","format-standard","hentry","category-ws23sql1001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1245","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=1245"}],"version-history":[{"count":2,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1245\/revisions"}],"predecessor-version":[{"id":1248,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1245\/revisions\/1248"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}