sqlserver创建视图记录

create  view tb_sys_user as
SELECT   loginname AS userno, loginname, username, SUBSTRING(sys.fn_sqlvarbasetostr(HashBytes('MD5', pwd)), 3, 32) 
                AS pwd, sex, old, deptno, phone, mobile, EMAIL, CREDENTIALSTYPE, CREDENTIALSNO, UPDATETIME, remark, 
                userstate AS state, 'boy5.jpg' AS avatar
FROM      MIS_workflow.dbo.tb_sys_user
UNION 
select userno, loginname, username, pwd, sex, old, deptno, phone, mobile, EMAIL, CREDENTIALSTYPE, CREDENTIALSNO, UPDATETIME, remark, 
state, 'boy5.jpg' AS avatar from tb_sys_user_bak;



create view tb_sys_dept as
SELECT  CONVERT(varchar(32),deptno) deptno, deptname, CONVERT(varchar(32),parentno) as parentno, updatetime, state, CONVERT(varchar(32),deptno) AS seq
FROM      MIS_workflow.dbo.tb_sys_dept
UNION
select deptno, deptname, CONVERT(varchar(32),parentno), updatetime, state, CONVERT(varchar(32),seq) as seq from tb_sys_dept_bak;