Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You query a database that includes two tables: Project and Task. The Project table includes the following columns:
The Task table includes the following columns:
You plan to run the following query to update tasks that are not yet started:
UPDATE Task SET StartTime = GETDATE() WHERE StartTime IS NULL
You need to return the total count of tasks that are impacted by this UPDATE operation, but are not associated with a project.
What set of Transact-SQL statements should you run?
A.
B.
C.
D.
CristianCruz
Highly Voted 5 years, 2 months agoAnirudh_net
Most Recent 3 years, 4 months agoVermonster
4 years, 7 months agochaoxes
5 years agoMountie
4 years, 10 months ago