Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution that might meet the stated goals. Some question sets might have
more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
With the INSERT INTO..VALUES statement we can insert both values with just one statement. This ensures
that both records or neither is inserted.
https://msdn.microsoft.com/en-us/library/ms174335.aspx
THE CORRECT ANSWER IS YES.
Inserting multiple rows of data
INSERT INTO Production.UnitMeasure
VALUES (N’FT2′, N’Square Feet ‘, ‘20080923’), (N’Y’, N’Yards’, ‘20080923’)
, (N’Y3′, N’Cubic Yards’, ‘20080923’);
fuente:microsoft
4
0
error of sintax –>”jossef’
INSERT INTO test.customer (FirstName,Lastname,DateOfBirthday,CreditLimit)
VALUES (‘yvonne ‘,’Mc Kay’,’1984-05-25′,9000)
,(”jossef’,’Goldberg’,’1995-06-03′,5500)
the answer is no.
2
0
Tested with creditlimit > 10000 and not one of the values where inserted.
I think there should be an begin transaction and commit statement in the query.
0
3
The thing in this question was that it presents “no town details” instead of “NULL” or empty string.
This is quite ambiguous and I hope that in the exam they can be as crystal clear as water with their examples.
So the answer is correct. However, there is some maneuvers in the table data exhibition that can deceive the more literal minded people
STAY ALERT
0
0
If the “Jossef’ in the second values set is there, it’s a syntax error and answer is NO. If that syntax error were not there, the answer would be YES.
INSERT
VALUES( ), (), ()
…statement requires all value records to be inserted correctly, else none are inserted.
0
0