主题：[求助]关于SQL视图修改的问题

SEL ECT     a.FInterID AS id, a.FBillNo AS 单据编号, a.FCheckDate AS 审核日期, a.FDate AS 日期, a.FStatus AS 订单状态, (CASE WHEN a.FStatus = 0 THEN NULL ELSE 'Y' END)
                      AS 审核标志, (CASE WHEN a.FStatus = 3 THEN 'Y' ELSE NULL END) AS 关闭标志, b.FEntryID AS Sn, b.FItemID AS SerNo, b.FQty AS 数量, b.FNote AS 备注,
                      b.FDate AS 交货日期, b.FStockQty AS 入库数量, b.FQty - b.FStockQty AS 未进仓数量, b.FPrice AS 单价, b.FAmount AS 金额, c.FFullNumber AS 供应商代码,
                      c.FName AS 供应商, d.FName AS 物料名称, d.FModel AS 规格型号, d.FNumber AS 物料代码, e.FName AS 单位, f.FName AS 审核人, g.FName AS 制单人,
                      h.采购负责人, j.确认交期, (CASE WHEN j.订单状态 = 3 THEN 'Y' ELSE NULL END) AS 完成标志
FROM         AIS20181207194554.dbo.POOrder AS a LEFT OUTER JOIN
                      AIS20181207194554.dbo.POOrderEntry AS b ON a.FInterID = b.FInterID LEFT OUTER JOIN
                      AIS20181207194554.dbo.t_Item AS c ON a.FSupplyID = c.FItemID LEFT OUTER JOIN
                      AIS20181207194554.dbo.t_ICItemCore AS d ON b.FItemID = d.FItemID LEFT OUTER JOIN
                      AIS20181207194554.dbo.t_MeasureUnit AS e ON b.FUnitID = e.FItemID LEFT OUTER JOIN
                      AIS20181207194554.dbo.t_User AS f ON a.FCheckerID = f.FUserID LEFT OUTER JOIN
                      AIS20181207194554.dbo.t_User AS g ON a.FBillerID = g.FUserID LEFT OUTER JOIN
                      dbo.物料表 AS h ON b.FItemID = h.ID LEFT OUTER JOIN
                      dbo.采购订单追踪表 AS j ON a.FInterID = j.订单ID AND b.FEntryID = j.序号

 

 

SQL 视图里的语句 ，现在数据库的名称更改为AIS20141204112434 目前数据库里的视图比较多（大约四十多个），如何快速批量的将AIS20181207194554更改为AIS20141204112434

把数据库视图导出为脚本，然后批量替换脚本里的内容，再执行脚本更新即可

 

老师，如何执行脚本更新！

 

需要比较麻烦的存储过程才能修改的。1、读取所有视图语句；2、批量修改视图定义。

 

建议你还是一个一个的打开视图，然后用工具查找替换掉吧。没有简单方法的。