如何提高效率
检视表
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
检视表
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