sql-server

Basic syntax DATEADD(, , ) -- Add 5 days to 04/23/2021 DATEADD(DAY, 5, '2021-04-23') -- Substract 5 days to 04/23/2021 DATEADD(MONTH, -...

A little reminder of how to use while loop with SQL. Basic structure DECLARE @Count INT SET @Count = 0 WHILE(@Count < 11) BEGIN PRI...

Let's have a preview of this amazing thing that is the Table variable in SQL Server. Basic syntax DECLARE @DevExperts TABLE (Id INT PRIMA...