[MSSQL] SQL語法筆記

字串

分隔字串擷取(類似split)

SELECT PARSENAME(REPLACE('Hello John Smith', ' ', '.'), 2) 
-- => Hello

SELECT PARSENAME(REPLACE('Hello John Smith', ' ', '.'), 0) 
-- => Smith

時間

時間差

SELECT DATEDIFF(DAY,GETDATE(),'2017-08-01')
-- => 4

DATEDIFF(day, DATEADD(day, -365, GETDATE()), a.PaidDate) > 0
-- => 5