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 ‘oeABC12345’.
• 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.
B.
C.
D.
