Guest User

Untitled

a guest
Jun 22nd, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. ALTER FUNCTION [dbo].[Foo_HiJonSkeet]
  2. (
  3. @ClientGuid NVARCHAR(50)
  4. )
  5. RETURNS TABLE
  6. AS
  7. RETURN
  8. (
  9. SELECT KEY_TBL.[Key] as LogEntryId,
  10. KEY_TBL.RANK as Relevance
  11. FROM CONTAINSTABLE(LogEntries, ClientGuid, @ClientGuid) AS KEY_TBL
  12. )
  13.  
  14.  
  15. SELECT * FROM Foo_HiJonSkeet('8b')
  16.  
  17. SELECT * FROM Foo_HiJonSkeet('"8b*"')
Add Comment
Please, Sign In to add comment