SQL Commands

-----------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%'