-----------Transact SQL ------------
---- creation of table
create table Sanjeev(P_Id integer, LastName nvarchar(255), FirstName nvarchar(255), Address nvarchar(255), City nvarchar(255))
---Dropping Table
Drop Table Sanjeev
---Insertion of values into table
insert into Sanjeev values(1,'Hansen','Ola','Timoteivn 10','Sandnes');
insert into Sanjeev values(2,'Svendson','Tove','Borgvn 23','Sandnes');
insert into Sanjeev values(3,'Pettersen','Kari','Storgt 20','Stavanger');
----To view the schema of a table
select LastName, FirstName from Sanjeev;
Select * from Sanjeev
---Deletion of of a row in a table
delete from Sanjeev where LastName='Hansen'
--- Usage of Distinct
select Distinct City from Sanjeev
---Usage of Where Condition
Select * from Sanjeev where City!='Stavanger';
---Usage of AND & OR Operators
Select * From Sanjeev Where FirstName='Tove' AND LastName='Svendson';
Select * From Sanjeev Where LastName='Svendson' AND (FirstName='Tove' OR FirstName='Ola')
---Order by
Select * From Sanjeev Order By P_ID DESC
---inserting rows
insert into Sanjeev values(4, 'Nilsen', 'Johan', 'Storgt 20', 'Stavanger');
insert into Sanjeev(P_Id, LastName, FirstName) Values(5, 'Tjessem', 'Jakob');
Select * from Sanjeev
---Updating the Table
Update Sanjeev set Address='Nissestien 67', City='Sandnes'
Where LastName='Tjessem' AND FirstName='Jakob'
Update Sanjeev set Address='Nissestein 67', City='Sandnes'
----Deletion of Table
Delete from Sanjeev where LastName='Tjessem' AND FirstName='Jakob'
Delete from College
Delete * from College
Select * from Sanjeev
--- Top Keyword Usage
Select TOP (2) * from Sanjeev
----Like
Select * from Sanjeev Where City Like 's%' --- Prints Words Starts with S
Select * from Sanjeev where city like '%s' ---- prints words ends with S
Select * from Sanjeev where LastName Like '%Ven%'
