DECLARE @INFO VARCHAR(50);
--ZAD 2
IF(SELECT COUNT(*) FROM EMP)<16
	BEGIN
	 INSERT INTO EMP (EMPNO,ENAME,SAL) VALUES (1234,'Kowalski',1000);
	 SET @INFO = 'DODANO KOWALSKIEGO';
	 END
	 ELSE
		SET @INFO ='NIE WSTAWIONO DANYCH';
	PRINT @INFO;
	GO
--ZAD 3
CREATE PROCEDURE ZAROBKI
	@PAR INT
	AS 
	BEGIN
		SELECT * FROM EMP
		WHERE SAL>@PAR;
	END
	GO
	EXECUTE ZAROBKI 999
	GO
-- ZAD 4
CREATE PROCEDURE CREATEDZIAL
@DEPTN INT,
@DNAME VARCHAR (14),
@DLOC VARCHAR (13)
AS

BEGIN
	IF NOT EXISTS(
		SELECT * FROM DEPT 
		WHERE DEPT.DEPTNO=@DEPTN 
		OR DEPT.DNAME=@DNAME 
		OR DEPT.LOC=@DLOC)
			INSERT INTO DEPT 
				VALUES (@DEPTN,@DNAME,@DLOC);
		ELSE
		PRINT 'ISTNIEJE';
	END
GO

EXECUTE CREATEDZIAL 12345,'DZIAL1',WWA

SELECT * FROM DEPT;
GO
--ZAD 5

CREATE PROCEDURE CREATEEMPLOYEE
@ENAME VARCHAR(10),
@EDNO INT

AS
BEGIN
DECLARE @ESAL INT;
DECLARE @EMPN INT;
	IF EXISTS (SELECT 'X' FROM DEPT
					WHERE DEPT.DEPTNO=@EDNO)
					BEGIN
						SELECT @EMPN= (MAX(EMPNO)+1) FROM EMP;
						INSERT INTO EMP(EMPNO,ENAME,SAL,DEPTNO) 
							VALUES (@EMPN,@ENAME,1000,@EDNO);
					END
					ELSE
						PRINT 'DZIAL NIE ISTNIEJE';
END
GO
EXECUTE CREATEEMPLOYEE 'KRZAK',123
SELECT * FROM EMP;
DELETE FROM EMP WHERE EMP.ENAME='KRZAK';