use master
go
if exists( select * from sysdatabases where name='LeetCode')
begin
drop database LeetCode
select 1 as deleted_LeetCode
end
create database LeetCode
use LeetCode
go
if exists(select * from sysobjects where name='Employee')
drop table Employee
create table Employee
(
employee_id int primary key,
name varchar(20),
experience_years int
)
insert into Employee values
--(1, 'Khaled', 3), (2, 'Ali', 2), (3, 'John', 1), (4, 'Doe', 2)
(1,'qk',11),(2,'prqvt',22),(3,'nfeltfjwi',22),(4,'ljyaezj',27),(5,'y',23),(6,'sipmi',18),(7,'xshwcocj',29),(8,'ifpyx',16),(9,'arn',18),(10,'fyqblblx',9),(11,'pqkwek',17),(12,'ufirmczjau',9),(13,'w',28),(14,'hksbhleeen',6),(15,'rnnxr',15),(16,'ymc',4),(17,'hzzpjre',29),(18,'sesmyrkrc',30),(19,'zr',4),(20,'trky',5),(21,'k',28),(22,'chwum',22),(23,'aj',20),(24,'yqrovlxki',0),(25,'juec',17),(26,'kre',15),(27,'y',4),(28,'kmhf',12),(29,'edcj',2),(30,'vv',4),(31,'zysb',14),(32,'dthvenxeqt',7),(33,'yvr',24),(34,'mqxt',11),(35,'yduucuh',25),(36,'a',30),(37,'fftbrtj',22),(38,'jwsdgsaz',7),(39,'pxah',6),(40,'rj',3),(41,'hsrvgjp',15),(42,'ylbbtheeyb',15),(43,'fywjflxlih',26),(44,'lofy',22),(45,'mkrisafjz',8),(46,'gt',2),(47,'hpmasdxevx',0),(48,'jbajov',11),(49,'ibnntts',3),(50,'tbvkbmxjh',5),(51,'zidspwa',10),(52,'giu',11),(53,'upvgk',7),(54,'mkappx',30),(55,'htvri',17),(56,'ofxyvuha',4),(57,'c',24),(58,'bctxixy',5),(59,'ut',16)
go
if exists(select * from sysobjects where name='Project')
drop table Project
create table Project
(
project_id int,
employee_id int,
constraint pk_project primary key(project_id, employee_id),
constraint fk_employee foreign key(employee_id) references Employee(employee_id)
)
insert into Project values
--(1, 1),(1, 2),(1, 3),(2, 1),(2, 4)
(1,2),(1,37),(1,3),(1,38),(1,4),(1,20),(1,14),(1,44),(1,29),(1,41),(1,51),(1,56),(1,34),(1,12),(1,31),(1,13),(1,48),(1,15),(1,23),(1,45),(1,5),(1,11),(1,25),(1,54),(1,8),(1,7),(1,36),(1,52),(1,6),(1,18),(1,57),(1,26),(1,43),(1,32),(1,55),(1,1),(1,16),(1,39),(1,50),(1,49),(1,28),(1,53),(1,17),(1,10),(1,40),(1,27),(1,22),(1,21),(2,45),(2,40),(2,21),(2,57),(2,53),(2,47),(2,33),(2,36),(2,55),(2,58),(2,49),(2,24),(2,16),(2,23),(2,18),(2,6),(2,46),(2,22),(2,41),(2,4),(2,28),(2,37),(2,10),(2,11),(2,44),(2,31),(2,5),(2,48),(2,43),(2,34),(2,12),(2,30),(2,42),(2,39),(2,35),(2,29),(2,54),(2,7),(2,50),(2,9),(3,36),(3,2),(3,40),(3,23),(3,57),(3,17),(3,11),(3,43),(3,21),(3,51),(3,3),(3,32),(3,19),(3,10),(3,56),(3,16),(3,55),(3,39),(
sqlserver 均值保留小数
最新推荐文章于 2022-06-07 22:29:14 发布