Which Transact-SQL statement should you use?

Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns. You also use a full-text thesaurus to expand common bicycle terms. You need to write a full-text query that will not only match the exact word in the search, but also the meaning.
Which Transact-SQL statement should you use?

Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns. You also use a full-text thesaurus to expand common bicycle terms. You need to write a full-text query that will not only match the exact word in the search, but also the meaning.
Which Transact-SQL statement should you use?

A.
SELECT * FROM Inventory
WHERE FREETEXT (*, ‘cycle’))

B.
SELECT * FROM Inventory
WHERE CONTAINS (*, ‘cycle’)

C.
SELECT * FROM Inventory
WHERE Description LIKE ‘%cycle%’

D.
SELECT * FROM Inventory
WHERE CONTAINS (*, ‘FormsOf(Inflectional, cycle)’)



Leave a Reply 0

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