SQL

SQL Tutorial

SQL Commands

Data Definition Language Commands:

Create table Command:
Create table Student
(
StudID varchar(100) null,
Sub varchar(100) null
)
Go

Alter table Command:
Alter table Student Add Marks int
Go
Alter table Student Alter column StudID varchar(10)
Go
Insert into Student Values(1,’SQL’,100)
Insert into Student Values(2,’SQL’,100)
Go
Select * from Student
Go

Truncate table Command:
Truncate table Student
Go

Drop table Command:
Drop table Student

Data Manipulation Language Commads: Insert, Update, Delete

Insert into Student Values(1,’SQL’,99)
Go
Insert into Student(StudID, Sub) Values(1,’SQL’)
Go
Update Student Set Marks=100 Where StudID=1
Go
Update Student Set Sub=’Maths’, Marks=100 Where StudID=1
Go
Delete from Student1 Where StudID=1

Data Query Language Command: Select
Go
Select * from Student
Go
Select StudID,Sub from Student
Go
Select * from Student where StudID=1
Go
Select * into Student1 from Student
Go
Select * from Student1