mssql 数据库视图创建索引

 

在给视图创建索引的时候，报如上错误。

创建视图的sql如下：

 

create view v_hb_xinxi with SCHEMABINDING
as
select id,Title,content,age,jine,jytype1,jytype2,jytype3,photo1,photo2,photo3,photo4,photo5,diqu_id,fenlei_id,
addTime,djnumb,hfnumb,jpnumb,cwnumb,xjnumb,ljnumb,zjnumb,gsnumb,userid,username,email,phone,handphone,other,fileurl,deltype,pfenlei_id,tuijian,tjtime,mdiqu_id,pdiqu_id,fenlei_title,diqu_title,xx_ip,zdtime,gongyi,biaoqian,fctime,bkzd1,bkzd2,telimg,otherimg,emilimg,zhiding,bqsm,bqbg,bkzd3,bkzd4,bkzd5,bkzd6,bkzd7,
bkzd8,mapoint,xiaoqu_id,addtime1,sfenlei_id,address,weburl,xxpwd,dqbieming,flbieming,endtime,maxjine,maxage,taddtime
 from dbo.xinxi  where  addtime  > '2011-08-01'

 

原因是后台条件的错误，换成如下的方式就没问题了：

 

create view v_hb_xinxi with SCHEMABINDING
as
select id,Title,content,age,jine,jytype1,jytype2,jytype3,photo1,photo2,photo3,photo4,photo5,diqu_id,fenlei_id,
addTime,djnumb,hfnumb,jpnumb,cwnumb,xjnumb,ljnumb,zjnumb,gsnumb,userid,username,email,phone,handphone,other,fileurl,deltype,pfenlei_id,tuijian,tjtime,mdiqu_id,
pdiqu_id,fenlei_title,diqu_title,xx_ip,zdtime,gongyi,biaoqian,fctime,bkzd1,bkzd2,telimg,otherimg,emilimg,zhiding,bqsm,bqbg,bkzd3,bkzd4,bkzd5,bkzd6,bkzd7,
bkzd8,mapoint,xiaoqu_id,addtime1,sfenlei_id,address,weburl,xxpwd,dqbieming,flbieming,endtime,maxjine,maxage,taddtime
 from dbo.xinxi  where convert(varchar(10),addTime,120) > '2011-08-01'