Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER FUNCTION [dbo].[Foo_HiJonSkeet]
- (
- @ClientGuid NVARCHAR(50)
- )
- RETURNS TABLE
- AS
- RETURN
- (
- SELECT KEY_TBL.[Key] as LogEntryId,
- KEY_TBL.RANK as Relevance
- FROM CONTAINSTABLE(LogEntries, ClientGuid, @ClientGuid) AS KEY_TBL
- )
- SELECT * FROM Foo_HiJonSkeet('8b')
- SELECT * FROM Foo_HiJonSkeet('"8b*"')
Add Comment
Please, Sign In to add comment