lyfz_repos/经典版源码/document/数据库维护脚本/SQLQuery5.sql


SELECT [bak1] as '备份原片',[bak2] as '备份初修',[bak3] as '备份精修',[bak4] as '备份设计'FROM [dbo].[version]

SELECT [bak11] as '备份分店原片',[bak22] as '备份分店初修',[bak33] as '备份分店精修',[bak44] as '备份分店设计' FROM [dbo].[version]

SELECT [check1] as '删除原片'
      ,[check2] as '删除初修'
      ,[check3] as '删除精修'
      ,[check4] as '删除设计'
      ,[edit1] as '删除原片时间'
      ,[edit2] as '删除初修时间'
      ,[edit3] as '删除精修时间'
      ,[edit4] as '删除设计时间'
FROM [dbo].[version]


SELECT [delcheck1] as '删除备份的原片'
      ,[delcheck2] as '删除备份的初修'
      ,[delcheck3] as '删除备份的精修'
      ,[delcheck4] as '删除备份的设计'
      ,[deledit1]  as '删除备份的原片时间'
      ,[deledit2]  as '删除备份的初修时间'
      ,[deledit3]  as '删除备份的精修时间'
      ,[deledit4]  as '删除备份的设计时间'
FROM [dbo].[version]