#sql-server

Basic syntax DATEADD(<Unit of time>, <Units>, <Date>) -- Add 5 days to 04/23/2021 DATEADD(DAY, 5, '2021-04-23') -- Substract 5 days to 04/23/2021 DATEADD(MONTH, -5, '2021-04-23') Units

A little reminder of how to use while loop with SQL. Basic structure DECLARE @Count INT SET @Count = 0 WHILE(@Count < 11) BEGIN PRINT 'I have walked ' + CONVERT(VARCHAR, @Count) + ' meters today' SET

Let's have a preview of this amazing thing that is the Table variable in SQL Server. Basic syntax DECLARE @DevExperts TABLE (Id INT PRIMARY KEY IDENTITY(1,1), Name VARCHAR(MAX), Country VARCHAR(MAX)) The

Spotlight Cloud SQL Server performance monitoring and diagnostics! Screenshots Hunter's comment really cool tool and totally free so you can visualize your sql server in the cloud, great for monitoring