SQLServer2005找不到查询分析器,如何执行以下语句?
SQLServer2005找不到查询分析器,如何执行以下语句?
create database factory
use factory
create table worker(
职工号 int not null primary key,
姓名 char (8),
性别 char (2),
出生日期 datetime ,
党员否 bit,
参加工作 datetime,
部门号 int )
create table depart(
部门号 int not null primary key,
部门名 char (10))
create table salary(
职工号 int not null ,
日期 datetime not null,
工资 decimal null
CONSTRAINT [PK_salary] PRIMARY KEY CLUSTERED
(
职工号,
日期
)
)
insert depart values (1,'财务处')
insert depart values (2,'人事处')
insert depart values (3,'市场部')
insert worker values (01,'孙华','男','1952/01/03','1','1970/10/10','1')
insert worker values (03,'陈明','男','1945/05/08','0','1965/01/01','2')
insert worker values (07,'程西','女','1980/06/10','0','02/07/10','1')
insert worker values (02,'孙天奇','女','1965/03/10','1','1987/07/10','2')
insert worker values (09,'刘夫文','男','1942/01/11','0','1960/08/10','2')
insert worker values (10,'陈涛','男','1958/02/10','1','1984/07/12','2')
insert worker values (14,'李艺','女','1963/02/10','0','1990/07/20','3')
insert worker values (12,'李涵','男','1965/04/19','1','1989/07/10','3')
insert worker values (15,'魏杰','女','1970/01/10','0','1993/07/10','3')
insert worker values (06,'欧阳少兵','男','1971/12/09','1','1992/07/20','3')
insert worker values (04,'李华','男','1956/08/07','0','1983/07/20','3')
insert worker values (05,'余慧','男','1980/12/04','0','2002/07/10','3')
insert worker values (08,'张旗','男','1980/11/10','0','2002/07/10','2')
insert worker values (11,'刘欢','男','1952/10/08','0','1970/01/07','1')
insert worker values (13,'王小艳','女','1964/02/10','0','1993/07/10','3')
insert salary values (1,'04/02/03',1206.5)
insert salary values (2,'04/02/03',905)
insert salary values (3,'04/02/03',1355.6)
insert salary values (4,'04/02/03',1505.5)
insert salary values (5,'04/02/03',730.0)
insert salary values (6,'04/02/03',1085.0)
insert salary values (7,'04/02/03',755.8)
insert salary values (8,'04/02/03',733.0)
insert salary values (9,'04/02/03',2011.8)
insert salary values (10,'04/02/03',1250.8)
insert salary values (11,'04/02/03',1255.0)
insert salary values (12,'04/02/03',1350.0)
insert salary values (13,'04/02/03',1205.0)
insert salary values (14,'04/02/03',1005.6)
insert salary values (15,'04/02/03',1105.0)
insert salary values (1,'04/01/01',1201.5)
insert salary values (2,'04/01/01',900.0)
insert salary values (4,'04