摘要： --一视图一if exists(select 1 from sysobjects where name=N'v_ExpenseQry' and type=N'V')drop view v_ExpenseQrygocreate view v_ExpenseQrywith encryptionas--一视图二if exists (select TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'v_ExpenseQry') DROP VIEW v_ExpenseQryGOcreat 阅读全文