[MSSQL]建立时间的检视表MS SQL

如何提高效率 检视表 CREATE VIEW V_DATE as SELECT         CONVERT(VARCHAR(10), GETDATE(), 120) AS today,                           REPLACE(CONVERT(varchar(8), GETDATE(), 108), ':', '') AS time,                           REPLACE(REPLACE(REPLACE(CONVERT(varchar, GETDATE(), 120), '-', ''), ' ', ''),                           ':', '') AS all_date, CONVERT(varchar(12), GETDATE(), 112) AS date,                           YEAR(GETDATE()) AS year, MONTH(GETDATE()) AS month, DAY(GETDATE())                           AS day, CONVERT(varchar(8), DATEADD(d, - 1, GETDATE()), 112) AS yestaday,                           CONVERT(varchar(8), DATEADD(d, 1, GETDATE()), 112) AS tomorrow