视图

StringBuilder sql = new StringBuilder();
sql.Append(@"if exists(select * from sys.objects where name='V_stu')
drop view V_stu"
);
//判断是否有视图
DbHelper.ExecuteSql(sql.ToString());
sql = new StringBuilder();
sql.Append(@"create view V_stu as select a.id,a.created_date,a.sname,case when a.sex>0 then '男' else '女' end as sex,a.sids,
teacher.tid,teacher.tname from student as a inner join s_t on a.sids=s_t.sids inner join teacher on s_t.tid=teacher.tid");
DbHelper.ExecuteSql(sql.ToString());