Discover
Communities
Decks
Login
Discover
Communities
Decks
Buy perks
Login
Signup
Topics
New
Trending
Hot
New
New
Friends
Trending
Hot
New
Controversial
Rising
Promoted
sql-server
lauweded
Programming & Dev
3y
DATEADD to change datetimes in 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
$ 0.977
21
1
lauweded
Programming & Dev
3y
Use of the While Loop with SQL
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
$ 26.591
86
3
lauweded
Programming & Dev
3y
Table variable in SQL Server
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
$ 1.229
24
teamhumble
steemhunt
5y
Spotlight Cloud - SQL Server performance monitoring and diagnostics!
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
$ 0.029
22
2
Top communities
Center