We have reached the end of the course with the introduction of functions.<\/p>\n
CREATE FUNCTION<\/span> quick_example(@<\/span>in_param VARCHAR<\/span>(50))\r\n -- passing a value into the function using parameter\r\n -- `@in_param` declared as a VARCHAR(50)<\/span>\r\n RETURNS VARCHAR<\/span>(50)\r\n AS<\/span>\r\n BEGIN<\/span>\r\n -- beginning of code do something when executing this \r\n -- function<\/span>\r\n DECLARE<\/span> @out_param VARCHAR<\/span>(50)\r\n -- receive value from it has been processed, using \r\n -- the same data type (VARCHAR(50))<\/span>\r\n SET<\/span> @out_param = CONCAT<\/span> (\r\n '`'<\/span>,\r\n @in_param,\r\n '` processed as `'<\/span>,\r\n UPPER<\/span>(@in_param),\r\n '`'<\/span>\r\n )\r\n -- passing a value. the original value processed<\/span>\r\n RETURN<\/span> @out_param\r\n -- printing the value of the output parameter<\/span>\r\n -- end of code to do something when executing this function<\/span>\r\n END;\r\n<\/span><\/pre>\n