sql sever 视图用来做搜索

    遇到个问题，网页中的搜索条要对好多表进行搜索，请教了别人用视图来做，这时就体现出来建表的时候统一字段的好处了。ok，视图上新建视图，直接在下面的输入框中输入

SELECT     id, subject, datetime, [content], 'yaowenzhongxin' AS biaoming, '要闻中心' AS mingcheng
FROM         dbo.yaowenzhongxin
UNION ALL
SELECT     id, subject, datetime, [content], 'meitiguanzhu' AS biaoming, '媒体关注' AS mingcheng
FROM         dbo.meitiguanzhu
UNION ALL
SELECT     id, subject, datetime, [content], 'shangjijingshen' AS biaoming, '上级精神' AS mingcheng
FROM         dbo.shangjijingshen

再给视图起个名字，如“sousuo”

然后就可以直接

   sql="select  biaoming,id,subject,datetime,mingcheng from sousuo where convert(varchar(10),datetime,120)LIKE'%"+SerchKey+"%'"

进行搜索了