SQL practice

Useful SQL practice procedure as below:-
Microsoft AQL Server - SQL Server Enterprise Manager
Click Microsoft SQL Server
right click SQL Server Group
New SQL Server registration
next
select ICIS-HP580A
Add
next
slect SQL Server Authentication
Click Promp for the SQL Server account information when connecting
select Add the SQL servers to an existinfSQL server group
next
finish
close


right click ICIS_HP580A
Slect connect
login name: E5706
password:E5706
In left panel
select ICIS-HP580A - database E5706

create table
- tools
- SQL Query Analyser

/create table

Create table persons_Lane
StudentID Varchar(10)
StudentName Varchar(60)
Age int,
DOB Datetime

click run icon
refresh table

/insert row
insert into persons_Lane (studentID, studentName, Age, DOB)
values ('S1234567T', 'Lane',30,'1/1/1980')

/drop column
Alter table person_Lane drop column studentID