You are a database developer for your organization. You create an application that uses a Transact-SQL variable to store user input data. The database collation is case-insensitive. The variable is constructed as shown in the following statement:

You need to implement a keyword search that meets the following requirements:

Which Transact-SQL statement should you use?

Question

You are a database developer for your organization. You create an application that uses a Transact-SQL variable to store user input data. The database collation is case-insensitive. The variable is constructed as shown in the following statement:

You need to implement a keyword search that meets the following requirements:

Which Transact-SQL statement should you use?

Accepted Answer

B. Option B

Answer

A. Option A

Answer

C. Option C

Answer

D. Option D

You are a database developer for your organization. You create an application that uses a Transact-SQL variable to store user input data. The database collation is case-insensitive. The variable is…

Question

Options

How the community answered

Community Discussion