learn

DATEDIFF_BIG (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft ...
GitHub

36.10 How to increment salaries of employees who have 2 years with the organization Datediff.sql

select id, firstname,lastname,DepartmentName,Salary,Salary * 1.15 as incrementedSalary,HireDate,datediff(YEAR,HireDAate,'2020-12-31') from employe ...
GitHub

36.14 How to find employees hired in last n months Datediff.sql

#INSERT INTO dbo.Emp (FirstName,LastName,HireDate) VALUES ('Alice', 'Ciccu','2021-01-07'); #INSERT INTO dbo.Emp (FirstName,LastName,HireDate) VALUES ('Paula ...