Which Transact-SQL statement should you run?

You administer a Microsoft SQL Server database named Orders.
The database contains a table named Customer that has the following definition:

You add a new data source to the application that inserts records into the Customer table. An example of a query that the application executes is shown below.

Users report that these new records are not displayed correctly. You review data in the table and observe that records from the new data source are displayed as shown below.

You need to change the database schema to support the characters coming in from this new data source. You need to achieve this goal without losing existing customer records.
Which Transact-SQL statement should you run?
A.

B.

C.

D.

E.

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.