//建表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Shop]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Shop]
GO
CREATE TABLE [dbo].[Shop] (
[Year] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[Month] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[CustomerCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MaterialCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[StockQty] [int] NULL ,
[Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Qty] [int] NULL ,
[Amount] [decimal](10, 1) NULL ,
[ShopCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
//测试数据
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2008' , '6' ,'XJ0032', 'C182W222003', 26, 'Shop', 22 ,1656.0 ,'SXJ236' )
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2009' , '5' ,'XJ0032', 'C182W222003', 26, 'Shop', 24 ,2656.0 ,'SXJ236' )
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2008' , '8' ,'X
我看了很多文章，写的太专业，能不能用大白话讲讲，就是怎么构建索引的，查的时候是怎么样的步骤，为什么比like快，是不是只要用contect，就一定会去查，比如
select * from table where contect('sdfsd',sdf) and ......
