The Agent table of a Microsoft SQL Server database contains several million rows. The database uses the SQL_Latin1_General_Cp1_CS_AS collation.
You need to ensure that the following requirements are met:
– The values of the StateRefID column conform to the pattern of 3 uppercase letters followed by 5 numeric digits, such as “ABC12345”.
– The StateRefID values are unique within the Agent table.
– The values of all records that will be inserted or updated in the Agent table are correctly formatted.
– Exisitng rows are ignored
Which Transact-SQL statement should you run?
A . Option A
B . Option B
C . Option C
D . Option D
Answer: A