Wednesday 9 October 2013

12. Display the details of all the stores having the word 'bike' in their name. In addition, ensure that the report contains the details of those stores that have the sales person ID as 277. You need to write a query so that the result set does not take a long time to be retrieved.

select * from Sales.Store
Where SalesPersonID=277
and Contains(Name,'Bike')

No comments:

Post a Comment