Foxtable(狐表)用户栏目专家坐堂 → [求助]关于SQL视图修改的问题


  共有1897人关注过本帖树形打印复制链接

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

帅哥哟,离线,有人找我吗?
2900819580
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:六尾狐 帖子:1326 积分:9637 威望:0 精华:0 注册:2015/6/30 8:46:00
[求助]关于SQL视图修改的问题  发帖心情 Post By:2019/6/10 20:02:00 [显示全部帖子]

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


 回到顶部
帅哥哟,离线,有人找我吗?
2900819580
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:六尾狐 帖子:1326 积分:9637 威望:0 精华:0 注册:2015/6/30 8:46:00
  发帖心情 Post By:2019/6/11 8:17:00 [显示全部帖子]

以下是引用有点蓝在2019/6/10 21:29:00的发言:
把数据库视图导出为脚本,然后批量替换脚本里的内容,再执行脚本更新即可

 

老师,如何执行脚本更新!


 回到顶部