|
-- Create Search View
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WikiSearch]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[WikiSearch]
GO
CREATE VIEW WikiSearch
AS
SELECT dbo.WikiWordIndex.WordID,
dbo.WikiWordIndex.WikiTopicID,
dbo.WikiTopic.WikiName,
dbo.WikiTopic.TopicTitle,
dbo.WikiTopicRank.TopicRank,
dbo.WikiWordIndex.WordCount,
dbo.WikiSummary.Summary,
dbo.WikiTopic.Updated,
dbo.WikiTopic.Author
FROM dbo.WikiWordIndex
INNER JOIN dbo.WikiTopic
ON dbo.WikiWordIndex.WikiTopicID = dbo.WikiTopic.WikiTopicID
LEFT OUTER JOIN dbo.WikiTopicRank
ON dbo.WikiWordIndex.WikiTopicID = dbo.WikiTopicRank.WikiTopicID
LEFT OUTER JOIN dbo.WikiSummary
ON dbo.WikiWordIndex.WikiTopicID = dbo.WikiSummary.WikiTopicID
GO
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Since 2001 I've been writing .NET applications in C# and architecting n-tier applications in the enterprise. Before that I worked as a tech writer for nine years. Don't bother doing the math. I'm old. Ever since I laid eyes on my first Commodore PET, I've been a technologist. I've worked in the software world for fifteen years. I started as a technical writer and learned to code from the best engineers as I worked with them in creating technical documentation. It was then that I learned that writing code was more fun and frankly easier than writing about code. I've been doing both ever since. You can visit my blog at http://www.tsjensen.com/blog.