CREATE VIEW BLVIEW
AS
SELECT F_ZYH AS 住院号,F_XM AS 姓名，F_BLH AS 病理号 FROM T_JCXX WHERE F_BGZT='已审核'
GO 




是sqlserver的，数据库用户名pathnet，密码4s3c2a1p
数据库名是pathnet