Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Get all dates between two given dates
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version'; WITH mytime AS( SELECT CAST('2011-01-01' AS DATETIME) DateValue UNION ALL SELECT Datevalue + 1 FROM mytime WHERE Datevalue + 1 < '2011-02-01') SELECT FORMAT(Datevalue, 'yyyy-MM-dd') FROM mytime
run
|
edit
|
history
|
help
0
wall
securing critical sections with manual locks in sql server
cms by valli
Campeonato2DLuizFelipe
Except Insert missing
Database ownership
First Query
TSQL - Unique string generator
9.12.2020
updated