You develop a Microsoft SQL Server database. You design a table to store product information. The table is defined as follows:
You need to meet the following requirements:
If a product has a product category value other than “REGULAR”, the product should have a sub-category with a length of two characters. If a product has the product category “REGULAR”, the product may or may not have a sub-category. Which Transact-SQL statement should you use?
A.
B.
C.
D.