SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewsInfo](
[NewsID] [nvarchar](50) NOT NULL,
[NewsTitle] [nvarchar](50) NULL,
CONSTRAINT [PK_NewsInfo] PRIMARY KEY CLUSTERED
(
[NewsID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE UNIQUE INDEX dianyun ON NewsInfo(NewsID)
CREATE FULLTEXT CATALOG ft AS DEFAULT;
CREATE FULLTEXT INDEX ON NewsInfo(NewsTitle) KEY INDEX dianyun;
SELECT * FROM NewsInfo
WHERE CONTAINS(NewsTitle, '日')
SELECT * FROM c
WHERE CONTAINS(b, 'ccc')
SELECT * FROM c
WHERE freetext(b, 'c')
