Alter, delete i update

ALTER TABLE poslovnipartner
ADD Telefon nvarchar(50)

ALTER TABLE poslovnipartner
DROP COLUMN Telefon

ALTER TABLE poslovnipartner
ADD
Telefon nvarchar(50),
nesto nvarchar(50)


UPDATE Kupac SET GradID=1
WHERE IDKupac BETWEEN 19978 AND 20000
SET Email=NULL,Telefon=NULL

SELECT * FROM Kupac
WHERE IDKupac IN(40,41,42)

DELETE FROM Kupac
WHERE IDKupac=20006
WHERE IDKupac BETWEEN 19978 AND 20005

SELECT Ime+' '+Prezime AS PunoIme
FROM kupac
WHERE Ime LIKE '%y%' OR Prezime