Edit View Query Project Debug Tools Window Help |4x口, .- New Query D & 9 . 3 hourglass ! Execute Debug のニ2课 A bject Explo. x SQLQuery27.sql - D.VIKRDGUulie (76)" SQLQuery13.sgl -D..VIKRDGUulie (62) SQLQuery14.sql - D.VJKRDGUulie (63)) x SQLQuery17.sql - D. VIKRDGVulie (66) SOLQuery26.sql - D.VIKRDGVulie (75)) - Solution Explorer Connect 3 DESKTOP-AVJKRDG Insert into dbo. Employees (EmpID, FirstName, LastName, Email, Salary, OfficeID, SupervisorID) values ('1', 'Matthew', 'Smith', "msmithệcms.com', '4500e','1',"), SQLQuery 10.sgl SQLQuery11.sql SQLQuery12.sql SOLQuery13.sgl SQLQuery14.sql SQLQuery15.sql a SQLQuery16.sql l ','940e0','1','1'), ','4','1'), ('2', 'Mark','Jones', 'mjonescms.com ('3', 'Luke', Rice','lrice@cms.com', '65000 ('4','John', "Rich', 'jrich@cms.com', '74000' ,'s', '1'), ,'James', 'Bolt', jbolt@cms.com', 40000 Databases a System Databases a hourglass Database Diagra ('5' e', '6', '2'), ('6', 'Peter', 'Pride', ppride@cms.com', '60000','3','3'), ('7', 'Eric', 'Potter', 'epotter@cms.com', '81000', 2','3'), ('8', 'Paul', "Davis', 'pdavis@cms.com', '103000','1','7'), ('9', 'David','Baxter', 'dbaxter@cms.com','75000','7','4'), ('10', 'Andrew', 'Lemmons', 'alemmons@cms.com, '53000','3', '4') Tables System Tables FileTables a SQLQuery17.sql aSQLQuery 18.sql Views a Synonyms a Programmability Ra Service Broker Storage Ha Security Security a Server Objects Replication Management a SQLQuery19.sql SQLQuery2.sql SQLQuery20.sql SQLQuery21.sql SQLQuery22.sql SQLQuery23.sql a SQLQuery24.sql SQLQuery25.sql SOLQuery26.sql SOLQuery27.sql 100 % a Messages nag 547, Level as, state e, Line 1 The INSERT statenent confaicted with the FOREION KEY SAME TABLE constraint " fnployees Enployees". The contiiet occurred in database "hourglass", tabe "ebo.Enployees", column EnpID. . The statenent has been terninated. Properties Current connection para Aggregate Status Connection failures
Edit View Query Project Debug Tools Window Help |4x口, .- New Query D & 9 . 3 hourglass ! Execute Debug のニ2课 A bject Explo. x SQLQuery27.sql - D.VIKRDGUulie (76)" SQLQuery13.sgl -D..VIKRDGUulie (62) SQLQuery14.sql - D.VJKRDGUulie (63)) x SQLQuery17.sql - D. VIKRDGVulie (66) SOLQuery26.sql - D.VIKRDGVulie (75)) - Solution Explorer Connect 3 DESKTOP-AVJKRDG Insert into dbo. Employees (EmpID, FirstName, LastName, Email, Salary, OfficeID, SupervisorID) values ('1', 'Matthew', 'Smith', "msmithệcms.com', '4500e','1',"), SQLQuery 10.sgl SQLQuery11.sql SQLQuery12.sql SOLQuery13.sgl SQLQuery14.sql SQLQuery15.sql a SQLQuery16.sql l ','940e0','1','1'), ','4','1'), ('2', 'Mark','Jones', 'mjonescms.com ('3', 'Luke', Rice','lrice@cms.com', '65000 ('4','John', "Rich', 'jrich@cms.com', '74000' ,'s', '1'), ,'James', 'Bolt', jbolt@cms.com', 40000 Databases a System Databases a hourglass Database Diagra ('5' e', '6', '2'), ('6', 'Peter', 'Pride', ppride@cms.com', '60000','3','3'), ('7', 'Eric', 'Potter', 'epotter@cms.com', '81000', 2','3'), ('8', 'Paul', "Davis', 'pdavis@cms.com', '103000','1','7'), ('9', 'David','Baxter', 'dbaxter@cms.com','75000','7','4'), ('10', 'Andrew', 'Lemmons', 'alemmons@cms.com, '53000','3', '4') Tables System Tables FileTables a SQLQuery17.sql aSQLQuery 18.sql Views a Synonyms a Programmability Ra Service Broker Storage Ha Security Security a Server Objects Replication Management a SQLQuery19.sql SQLQuery2.sql SQLQuery20.sql SQLQuery21.sql SQLQuery22.sql SQLQuery23.sql a SQLQuery24.sql SQLQuery25.sql SOLQuery26.sql SOLQuery27.sql 100 % a Messages nag 547, Level as, state e, Line 1 The INSERT statenent confaicted with the FOREION KEY SAME TABLE constraint " fnployees Enployees". The contiiet occurred in database "hourglass", tabe "ebo.Enployees", column EnpID. . The statenent has been terninated. Properties Current connection para Aggregate Status Connection failures
Chapter8: Sql Functions And Procedures
Section: Chapter Questions
Problem 9SCG: SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet...
Related questions
Question
My Professor created the needed tables and my job is to add the information to the tables. But i do not understand what is going wrong that my insert statement isnt working with the provided table information..
Transcribed Image Text:A SQLQuery14.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (63))* - Microsoft SQL Server Management Studio
File
Edit
View Query Project Debug Tools
Window Help
New Query
DM
hourglass
! Execute
Debug
Object Explo..
4 X SQLQuery27.sql - D..VJKRDG\Julie (76))*
SQLQuery 13.sql - D...VJKRDG\Julie (62))*
SQLQuery14.sql - D...VJKRDG\Julie (63))* X SQLQuery17.sql - D..VJKRDG\Julie (66))*
SQLQuery26.sql - D...VJKRDG\Julie (75))*
Solution Explorer
Connect
EInsert into dbo. Employees (EmpID, FirstName, LastName, Email, Salary, OfficeID, SupervisorID) values
('1','Matthew', 'Smith','msmith@cms.com','45000','1',''),
('2', 'Mark','Jones', 'mjones@cms.com ','94000','1','1'),
('3','Luke','Rice','lrice@cms.com','65000','4','1'),
('4','John', 'Rich','jrich@cms.com','74000', '5','1'),
('5','James', 'Bolt','jbolt@cms.com','40000','6','2'),
('6','Peter', 'Pride','ppride@cms.com','60000','3','3'),
('7','Eric', 'Potter','epotter@cms.com','81000',
('8','Paul', 'Davis','pdavis@cms.com','103000', '1','7'),
('9','David', 'Baxter','dbaxter@cms.com','75000', '7','4'),
('10','Andrew', 'Lemmons','alemmons@cms.com','53000','3','4')
B SQLQuery10.sql
E. SQLQuery11.sql
B SQLQuery12.sql
E SQLQuery13.sql
OO DESKTOP-AVJKRDG\S
DO Databases
E- System Databases
B0 hourglass
O Database Diagra
E SQLQuery14.sql
B SQLQuery15.sql
D Tables
'2','3'),
B. SQLQuery16.sql
E SQLQuery17.sql
B. SQLQuery18.sql
B SQLQuery19.sql
B SQLQuery2.sql
B SQLQuery20.sql
B SQLQuery21.sql
E. SQLQuery22.sql
E SQLQuery23.sql
-System Tables
O FileTables
+ Views
Synonyms
E- Programmability
+- Service Broker
Storage
Security
B- Security
E SQLQuery24.sql
E SQLQuery25.sql
E SQLQuery26.sql
E SQLQuery27.sql
E- Server Objects
100 %
Replication
B Messages
E- Management
Msg 547, Level 16, State e, Line 1
The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "fk_Employees_Employees". The conflict occurred in database "hourglass", table "dbo. Employees", column 'EmpID'.
The statement has been terminated.
Properties
Current connection parameters
Aggregate Status
Connection failures
Elapsed time
00:00:00.026
Finish time
3/13/2022 5:28:40 PM
Name
DESKTOP-AVJKRDG\S
Rows returned
Start time
3/13/2022 5:28:40 PM
State
Оpen
Connection
70 %
Connection name DESKTOP-AVJKRDG\S
Connection Details
A Query completed with errors.
DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows
Connection elapsec 00:00:00.026
Connection finish ti 3/13/2022 5:28:40 PM
Output
Connection rows re 0
Show output from:
Connection start tir 3/13/2022 5:28:40 PM
Connection state
Оpen
Name
The name of the connection.
Output
Find Results 1
Find Results 2
Ready
Ln 12
Col 1
Ch 1
OVR
I HE
Transcribed Image Text:A SQLQuery13.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (62))* - Microsoft SQL Server Management Studio
File
Edit
View Query Project Debug Tools
Window Help
New Query
DM
hourglass
! Execute
Debug
%3D
Solution Explorer
+ X SQLQuery27.sql - D...VJKRDG\Julie (76))*
ECREATE TABLE Employees
(EmpID int,
FirstName varchar(30),
LastName varchar(50),
Email varchar(50),
Object Explo..
SQLQuery13.sql - D...VJKRDG\Julie (62))* X SQLQuery14.sql - D..VJKRDG\Julie (63))*
SQLQuery17.sql - D...VJKRDG\Julie (66))*
SQLQuery26.sql - D...VJKRDG\Julie (75))*
Connect
E SQLQuery10.sql
E SQLQuery11.sql
B SQLQuery12.sql
B. SQLQuery13.sql
B SQLQuery14.sql
B. SQLQuery15.sql
B. SQLQuery16.sql
E SQLQuery17.sql
B SQLQuery18.sql
B SQLQuery19.sql
B SQLQuery2.sql
B SQLQuery20.sql
B SQLQuery21.sql
E. SQLQuery22.sql
E SQLQuery23.sql
OO DESKTOP-AVJKRDG\S
DO Databases
E- System Databases
B0 hourglass
O Database Diagra
Salary decimal(10, 2),
OfficeID int not null,
D Tables
SupervisorID int,
CONSTRAINT pk_Employees PRIMARY KEY (EmpID),
CONSTRAINT fk_Employees_Offices FOREIGN KEY (OfficeID) REFERENCES Offices,
CONSTRAINT fk_Employees_Employees FOREIGN KEY (SupervisorID) REFERENCES Employees)
System Tables
O FileTables
+ Views
Synonyms
ww
E- Programmability
SELECT*FROM Employees
|
exec sp_help Employees
+- Service Broker
Storage
Security
B- Security
E SQLQuery24.sql
E SQLQuery25.sql
E SQLQuery26.sql
E SQLQuery27.sql
- Server Objects
100 %
Replication
B Messages
E- Management
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Employees' in the database.
Properties
Current connection parameters
Aggregate Status
Connection failures
Elapsed time
00:00:00.015
Finish time
3/12/2022 10:23:20 P
Name
DESKTOP-AVJKRDG\S
Rows returned
Start time
3/12/2022 10:23:20 P
State
Open
Connection
100 %
Connection name DESKTOP-AVJKRDG\S
Connection Details
A Query completed with errors.
DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows
Connection elapsec 00:00:00.015
Connection finish ti 3/12/2022 10:23:20 P
Output
Connection rows re 0
Show output from:
Connection start tir 3/12/2022 10:23:20 P
Connection state
Оpen
Name
The name of the connection.
Output
Find Results 1
Find Results 2
Ready
Ln 14
Col 1
Ch 1
OVR
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning