Puzzle On DATEADD Function

Why are the values so similar can any one explain me? Please execute the below Query and see the result SELECT DATEADD(MONTH, 1, ‘2015-01-28’) SELECT DATEADD(MONTH, 1, ‘2015-01-29’) SELECT DATEADD(MONTH, 1, ‘2015-01-30’) SELECT DATEADD(MONTH, 1, ‘2015-01-31’) Write your explanation in the comments.

SQL SERVER – Puzzle .

CREATE TABLE #temp ( emp_name NVARCHAR(200) NOT NULL, emp_middlename NVARCHAR(200) NULL, emp_lastname NVARCHAR(200) NOT NULL ); INSERT INTO #temp VALUES( ‘SQL’, NULL, ‘Authority’ ); INSERT INTO #temp VALUES( ‘SQL’, ‘Server’, ‘Authority’ ); SELECT emp_name + emp_middlename + emp_lastname AS Result FROM #temp; DROP TABLE #temp; GO As you can see, the problem is getting the … More SQL SERVER – Puzzle .