SQL for beginners( defined with errors while enforcing constraints)
Error(s), warning(s): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__STATS__ID__0EE08316". The conflict occurred in database "rextester", table "dbo.STATION", column 'ID'.
|
sql server version |
1 |
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
|
|
ID |
CITY |
STATE |
LAT_N |
LONG_W |
1 |
13 |
Phoenix |
AZ |
33 |
112 |
2 |
44 |
Denver |
CO |
40 |
105 |
3 |
66 |
Caribou |
ME |
47 |
68 |
|
ID |
CITY |
STATE |
LAT_N |
LONG_W |
1 |
44 |
Denver |
CO |
40 |
105 |
2 |
66 |
Caribou |
ME |
47 |
68 |
|
ID |
CITY |
STATE |
1 |
13 |
Phoenix |
AZ |
2 |
44 |
Denver |
CO |
3 |
66 |
Caribou |
ME |
|
ID |
CITY |
STATE |
1 |
44 |
Denver |
CO |
2 |
66 |
Caribou |
ME |
|
ID |
MONTH |
TEMP_F |
RAIN_I |
1 |
13 |
1 |
57,4 |
0,31 |
2 |
13 |
7 |
91,7 |
5,15 |
3 |
44 |
1 |
27,3 |
0,18 |
4 |
44 |
7 |
74,8 |
2,11 |
5 |
66 |
1 |
6,7 |
2,1 |
6 |
66 |
7 |
65,8 |
4,52 |
|
ID |
CITY |
STATE |
LAT_N |
LONG_W |
ID |
MONTH |
TEMP_F |
RAIN_I |
1 |
13 |
Phoenix |
AZ |
33 |
112 |
13 |
1 |
57,4 |
0,31 |
2 |
13 |
Phoenix |
AZ |
33 |
112 |
13 |
7 |
91,7 |
5,15 |
3 |
44 |
Denver |
CO |
40 |
105 |
44 |
1 |
27,3 |
0,18 |
4 |
44 |
Denver |
CO |
40 |
105 |
44 |
7 |
74,8 |
2,11 |
5 |
66 |
Caribou |
ME |
47 |
68 |
66 |
1 |
6,7 |
2,1 |
6 |
66 |
Caribou |
ME |
47 |
68 |
66 |
7 |
65,8 |
4,52 |
|
month |
id |
rain_i |
temp_f |
1 |
1 |
66 |
2,1 |
6,7 |
2 |
1 |
13 |
0,31 |
57,4 |
3 |
1 |
44 |
0,18 |
27,3 |
4 |
7 |
13 |
5,15 |
91,7 |
5 |
7 |
66 |
4,52 |
65,8 |
6 |
7 |
44 |
2,11 |
74,8 |
|
month |
id |
rain_i |
temp_f |
1 |
7 |
13 |
5,15 |
91,7 |
2 |
7 |
66 |
4,52 |
65,8 |
3 |
7 |
44 |
2,11 |
74,8 |
4 |
1 |
66 |
2,1 |
6,7 |
5 |
1 |
13 |
0,31 |
57,4 |
6 |
1 |
44 |
0,18 |
27,3 |
|
lat_n |
city |
temp_f |
1 |
47 |
Caribou |
65,8 |
2 |
40 |
Denver |
74,8 |
3 |
33 |
Phoenix |
91,7 |
|
(No column name) |
(No column name) |
(No column name) |
ID |
1 |
91,7 |
57,4 |
2,73000004887581 |
13 |
2 |
74,8 |
27,3 |
1,14499995112419 |
44 |
3 |
65,8 |
6,7 |
3,30999994277954 |
66 |
|
ID |
CITY |
STATE |
LAT_N |
LONG_W |
1 |
13 |
Phoenix |
AZ |
33 |
112 |
2 |
44 |
Denver |
CO |
40 |
105 |
|
ID |
MONTH |
TEMP_C |
RAIN_C |
1 |
44 |
1 |
-2,611112 |
0,070866 |
2 |
66 |
1 |
-14,05556 |
0,8267699 |
|
ID |
MONTH |
TEMP_C |
RAIN_C |
1 |
13 |
1 |
14,11111 |
0,122047 |
2 |
13 |
7 |
33,16667 |
2,027555 |
3 |
44 |
1 |
-2,611112 |
0,070866 |
4 |
44 |
7 |
23,77778 |
0,830707 |
5 |
66 |
1 |
-14,05556 |
0,8267699 |
6 |
66 |
7 |
18,77778 |
1,779524 |
|
ID |
MONTH |
TEMP_F |
RAIN_I |
1 |
13 |
1 |
57,4 |
0,41 |
2 |
13 |
7 |
91,7 |
5,25 |
3 |
44 |
1 |
27,3 |
0,28 |
4 |
44 |
7 |
74,9 |
2,21 |
5 |
66 |
1 |
6,7 |
2,2 |
6 |
66 |
7 |
65,8 |
4,62 |
|
ID |
MONTH |
TEMP_F |
RAIN_I |
1 |
13 |
1 |
57,4 |
0,41 |
2 |
13 |
7 |
91,7 |
5,25 |
3 |
44 |
1 |
27,3 |
0,28 |
4 |
44 |
7 |
74,9 |
4,5 |
5 |
66 |
1 |
6,7 |
2,2 |
6 |
66 |
7 |
65,8 |
4,62 |
|
ID |
CITY |
STATE |
LAT_N |
LONG_W |
1 |
13 |
Phoenix |
AZ |
33 |
112 |
2 |
44 |
Denver |
CO |
40 |
105 |
|
ID |
MONTH |
TEMP_F |
RAIN_I |
1 |
13 |
1 |
57,4 |
0,41 |
2 |
44 |
1 |
27,3 |
0,28 |
|
ID |
MONTH |
TEMP_C |
RAIN_C |
1 |
13 |
1 |
14,11111 |
0,161417 |
2 |
44 |
1 |
-2,611112 |
0,110236 |
|
|