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