Create

use city
go
drop table cities
go
create table cities  (id nvarchar (10) primary key,name nvarchar (20),population int ,date_mod datetime)
go
exit


Insert

use city
go
insert into cities  (id,name,population,date_mod) values ('t1071',N'前橋',48517,'2001-5-24')
insert into cities  (id,name,population,date_mod) values ('t1072',N'高崎',19536,'2001-3-15')
insert into cities  (id,name,population,date_mod) values ('t1073',N'桐生',89714,'2001-7-30')
insert into cities  (id,name,population,date_mod) values ('t1074',N'沼田',54923,'2001-2-8')
insert into cities  (id,name,population,date_mod) values ('t1075',N'伊勢崎',36218,'2001-8-12')
insert into cities  (id,name,population,date_mod) values ('t1076',N'水上',82547,'2001-5-16')
insert into cities  (id,name,population,date_mod) values ('t1077',N'太田',93564,'2001-4-27')
insert into cities  (id,name,population,date_mod) values ('t1078',N'安中',78251,'2001-1-9')
insert into cities  (id,name,population,date_mod) values ('t1079',N'みどり',69342,'2001-11-12')
go
exit

Read

use city
go
select id,name,population,date_mod from cities
go
exit