Question: Consider the create SQL command below and the first line of the insert SQL command. Which of the following options represents the second line
Consider the create SQL command below and the first line of the insert SQL command. Which of the following options represents the second line of the insert command that would lead to a new row being created in the table? CREATE TABLE [order] ( orderID int primarykey, orderdate datetime2(1) not null, ordertype tinyint null ); INSERT INTO [order](orderID, orderdate) VALUES (1, '2018-11-10 8:00:00.1'); VALUES ('2018-11-10 8:00:00.1', 1); None of the options would run due to the structure of the table VALUES (1, '2018-11-10 8:00:00.1', 1);
Step by Step Solution
There are 3 Steps involved in it
The image shows a SQL create table command for a table named order with fields orderID orderdate and ... View full answer
Get step-by-step solutions from verified subject matter experts
