Which Transact-SQL statement should you use?

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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.