Wednesday 9 October 2013

07. Display the details of all the currencies that contain the words New and Dollar in their names. These words can be included in any order. In addition, you need to make sure that the query does not take too much time to execute.

select * from Sales.Currency
Where FreeText (Name,'"New" and "Dollar"')

No comments:

Post a Comment