今天在创建数据库视图 bed 遇到问题 create view [dbo].[bed] (brtm,mrn, pname, psex, age,deptbed, bedid, diag, rydate, cydate, zzys, ssview, id ) as select  mrn  ,mrn  , pname COLLATE CHINESE_PRC_CI_AS  , p

---1.先备份ur_ksdm表的数据 select * into ur_ksdm_linshi from  ur_ksdm ---2.删除ur_ksdm  表里数据 delete  ur_ksdm alter table ur_ksdm  alter column lrdm varchar(50); -- 3.把UR_DEPARTMENT表的(de_deptid,de_alph)字