reate database NTVETC
use NTVETC
create table Persons(P_Id int primary key not null,LastName char(22),FirstName
char(22),Adress char(20),City char(20))
insert into Persons values(1,'Hansen','Ola','Timoteivn 10','Sandnes')
insert into Persons values(2,'Svendson','Tove','Borgvn 23','Sandnes')
insert into Persons values(3,'Pettersen','Kari','Storgt 20','Stavanger')
insert into Persons values(4,'Girma','Duressa','Arjo','Arjo')
insert into Persons values(5,'Tekalegn','Lemi','Nekemte','Gidda')
insert into Persons values(6,'Asabe','Huluka','Adama','Adama')
select*from Persons
select*from Persons
Delete
delete from persons where P_Id=6
Update
update persons set LastName='Sami' where LastName='Svendson'
Alter
alter table persons add Nationality char(20)
alter table persons add Region char(23)
Distinct
SELECT DISTINCT City FROM Persons
SELECT * FROM Persons WHERE City='Sandnes'
SELECT * FROM Persons WHERE City='Gidda'
SELECT * FROM Persons WHERE FirstName='Tove'
SELECT * FROM Persons WHERE LastName='Girma'
SELECT * FROM Persons WHERE FirstName='Tove' AND LastName='Sami'
SELECT * FROM Persons WHERE FirstName='Duressa' AND LastName='Girma'
SELECT * FROM Persons WHERE FirstName='Lemi' AND LastName='Tekalegn'
SELECT * FROM Persons WHERE FirstName='Tove' OR FirstName='Ola'
SELECT * FROM Persons WHERE FirstName='Duressa' OR FirstName='Lemi'or
FirstName='Huluka'
SELECT * FROM Persons ORDER BY LastName
SELECT * FROM Persons ORDER BY adress
SELECT * FROM Persons ORDER BY LastName DESC
SELECT * FROM Persons ORDER BY LastName Asc
select*from Persons
DELETE FROM Persons WHERE LastName='Tekalegn' AND FirstName='Lemi'
SELECT * FROM Persons WHERE FirstName LIKE 'D%'
SELECT * FROM Persons WHERE FirstName LIKE 'T%'
SELECT * FROM Persons WHERE LastName LIKE 'T%'
SELECT * FROM persons WHERE lastName IN ('sami','Girma')
SELECT FirstName,LastName FROM Persons WHERE LastName = 'girma'
SELECT FirstName,LastName FROM Persons WHERE LastName <'m'
SELECT FirstName,LastName FROM Persons WHERE LastName >'m'
backup database NTVETC to disk='c:\e\h'
drop database NTVETC
restore database NTVETC from disk='c:\e\h'
backup database NTVETC to disk='c:\dd'
alter table persons add Nationality char(20)
--Date functions--
select CURRENT_TIMESTAMP
select DATEADD(month,2,'2018/08/25') as DateAdd
select DATEDIFF(year,'2018/03/10','2000/03/10')as datediff
select DATEPART(year,'2018/01/25')as datepartint
select CONVERT(int, 25.65);
select CONVERT(int, 25.85);
select CONVERT(varchar, 25.85);
select GETDATE()
--String functions and operators--
select ASCII('A')
select ASCII('Hello')
select ASCII('Tola')
select DEGREES(1.5);
select DEGREES(PI()*2);
select SQUARE(64)
select SQUARE(8)
select SQUARE(13)
select power(4,3)
select power(7,2)
select power(9,2)
select COS(2)
select COS(6)
select tan(2)
select COS(PI())
select COt(6)
select COt(-2)
select CEILING(25.75)
select CEILING(25)
select CEILING(25.75)
create login chala with password='chalatad'
backup database NTVETC to disk='c:\h\my backup file'
drop database NTVETC
restore database NTVETC from disk='c:\h\my backup file'
