Lab2ADB(26.09.18)

CREATE DATABASE lab2;
USE lab2;
CREATE TABLE employees (
E_ID VARCHAR(12) NOT NULL PRIMARY KEY,
E_Name VARCHAR(25) NOT NULL,
E_Address VARCHAR(55),
Salary INT NOT NULL,
Department VARCHAR(12)
)
INSERT INTO employees
(E_id, E_Name, E_Address, Salary, Department) VALUES
('E011','Rakib','Cumilla',64587,'HR'),
('E012','Rakib','Dhaka',24587,'IT'),
('E013','Rakiba','Dhaka',34587,'IT'),
('E014','Rasel','Chittagong',54587,'Management'),
('E015','Robin','Chadpur',24587,'Sale'),
('E016','Rubi','Dhaka',14587,'Sale'),
('E017','Kabir','Chadpur',28587,'Management'),
('E018','Rothi','Dhaka',28587,'HR');

print 'Hello Rashed'
DECLARE @i VARCHAR(25)
SET @i = '100000'
print(@i)
SELECT @i AS Print_value
/*print with column line*/

DECLARE @q FLOAT(20)
SET @q = 25.00
DECLARE @j FLOAT(20)
SET @j = 20.00

DECLARE @k FLOAT(20)
SET @k = 26.00

DECLARE @SUM FLOAT(20)
SET @SUM = @q+@j+@k
print(@SUM)

SET @SUM = @q*@j*@k
print(@SUM)

SET @SUM = @q-@j-@k
print(@SUM)

SET @SUM = (@q/@j)/@k
print(@SUM)

DECLARE @h FLOAT = 25.69
print @h

DECLARE @var INT = 0
while(@var<10)
BEGIN
    print('Rashed')
    SET @var=@var +1
END
/*
Pl SQl Procedure
Pl Sql declare
begin

Function or work

End

*/
/*
IF ELSE
Begin
    if
        begin

        end
end


*/
SELECT * FROM employees

DECLARE @name VARCHAR(25)
DECLARE @salry INT
SET @name= (SELECT E_Name FROM employees WHERE E_ID = 'E011')
SET @salry =(SELECT salary FROM employees WHERE E_ID = 'E011')

print @name
print @salry

print 'Employee Name is '+@name+' & his '+CAST(@salry AS VARCHAR(25))+'.'

/*"cast" user for change data type in PL sql*/