Discover
Communities
Decks
Login
Discover
Communities
Decks
Buy perks
Login
Signup
Topics
New
Trending
Hot
New
New
Friends
Trending
Hot
New
Controversial
Rising
Promoted
dev-girl
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
1
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
1
Top communities
Center