· 7 years ago · Sep 12, 2018, 03:34 PM
1IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ATHLETE]') AND type in (N'U'))
2 DROP TABLE [dbo].[ATHLETE]
3GO
4
5CREATE TABLE ATHLETE (
6 athleteID INT IDENTITY(1,1),
7 athleteFirstName VARCHAR(20) NOT NULL,
8 athleteLastName VARCHAR(30) NOT NULL,
9 athleteDateofBirth DATE,
10 athleteJerseyNumber CHAR(2),
11 athletePosition CHAR(2) NOT NULL,
12 athleteBattingAvg DECIMAL(4,3) NOT NULL,
13 athleteNationality VARCHAR(30)
14
15 CONSTRAINT pk_Athlete_athleteID PRIMARY KEY(athleteID)
16)
17
18
19INSERT INTO ATHLETE
20 (athleteFirstName, athleteLastName, athleteDateofBirth, athleteJerseyNumber, athletePosition, athleteBattingAvg, athleteNationality)
21VALUES
22 ('Troy', 'Tulowitzki', '1984-10-10', '2', 'SS', 0.249, 'USA'),
23 ('Kevin', 'Pillar', '1989-01-04', '11', 'OF', 0.256, 'USA'),
24 ('Justin', 'Smoak', '1986-12-05', '14', '1B', 0.270, 'USA'),
25 ('Aledmys', 'Diaz', '1990-08-01', '36', 'SS', 0.259, 'Cuba'),
26 ('Josh', 'Donaldson', '1985-12-08', '20', '3B', 0.270, 'USA'),
27 ('Russell', 'Martin', '1983-02-15', '55', 'C', 0.221, 'Canada'),
28 ('Jose', 'Abreu', '1987-01-29', '79', '1B', 0.304, 'Cuba'),
29 ('Kevin', 'Kiermaier', '1990-04-22', '39', 'OF', 0.276, 'USA'),
30 ('Nolan', 'Arenado', '1991-04-16', '28', '3B', 0.309, 'USA'),
31 ('Mike', 'Trout', '1991-08-07', '27', 'OF', 0.306, 'USA'),
32 ('Aaron', 'Judge', '1992-04-26', '99', 'OF', 0.284, 'USA'),
33 ('Jose', 'Altuve', '1990-05-06', '27', '2B', 0.346, 'Venezuela'),
34 ('Joey', 'Votto', '1983-09-10', '19', '1B', 0.320, 'Canada'),
35 ('Giancarlo', 'Stanton','1989-11-08', '27', 'OF', 0.281, 'USA')