orichisonic的专栏

SELECT GETDATE() AS CurrentDateTime 获得当天日期时间select dateadd(day, -1, getdate()) 获得前一天的日期时间Select Convert(DateTime,Convert(Varchar(10),dateadd(day, -1, getdate()),120)) 获得前一天的凌晨0点的时间SELECT DATEADD(day,DATEDIFF(day,'20010101',CURRENT_TIMESTAMP),'2001.

SELECT al.NUHours,al.NUHours/2920,ji.JoinGroupDate,datediff(day,ji.JoinGroupDate,GETDATE()) AS 天数,cast(cast(al.NUHours*datediff(day,ji.JoinGroupDate,GETDATE())as decimal(38,2))/2920 AS DECIMAL(38,1)),floor((cast(cast(al.NUHours*datediff(day,ji.JoinGroupDa

1.输入一个查询语句看看SQL Server是如何显示查询计划的吧。select v.OrderID, v.CustomerID, v.CustomerName, v.OrderDate, v.SumMoney, v.Finishedfrom OrdersView as vwhere v.OrderDate >= '2010-12-1' and v.OrderDate '201

 使用SELECT INTO 和 INSERT INTO SELECT 表复制语句了。 　　1.INSERT INTO SELECT语句　　语句形式为：Insert into Table2(field1,field2,...) select value1,value2,... from Table1 [where column =value][]为可选内容要求目标表Table2必须在由...

  SELECT al.NUHours,al.NUHours/2920,ji.JoinGroupDate,datediff(day,ji.JoinGroupDate,GETDATE()) AS 天数,cast(cast(al.NUHours*datediff(day,ji.JoinGroupDate,GETDATE())as decimal(38,2))/2920 AS DECIMAL(...

  SELECT GETDATE() AS CurrentDateTime 获得当天日期时间select dateadd(day, -1, getdate()) 获得前一天的日期时间Select Convert(DateTime,Convert(Varchar(10),dateadd(day, -1, getdate()),120)) 获得前一天的凌晨0点的时间 SELEC...