I would like to know a sql query to find all missing dates between two dates , suppose my sql table is as below
|
ID |
Date |
|
1 |
2018-1-10 |
|
2 |
2018-1-12 |
|
3 |
2018-1-13 |
|
4 |
2018-1-15 |
|
5 |
2018-1-17 |
|
6 |
2018-1-18 |
|
7 |
2018-1-20 |
|
8 |
2018-1-21 |
I need to run sql query which will return missing dates from date column like ‘2018-1-11’ , ‘2018-1-14’.
...
Hi, I have searched on google about links to download complete sql server express 2016 full version but i wasn't able to find it, as previous version of SQL Server Express were available in both web and full downloads, so can anyone provide me link(s) to download full sql server express 2016(preferred) or 2017 edition or 2019 Express.
Need complete offline installer, thanks
...I want sum of two column values from two different tables, how can I do it using SQL?
Suppose, these are my two tables, Table 1
...When I am trying to run a script of 300mb on SQL Server 2012 I am getting this issue
Cannot execute script: Insufficient memory to continue the execution of the program (mscorlib)here is the image
...
Hello, I need to check my last month records in SQL server management studio, and I would like to know how can I get record of only last month from a table using SQL query, I have DateCreated column to check when the row was added in the table.
For example, as It's may,2018 and I would like to run a Query to get April,2018 records using sql server query.
If possible, I would also like to know, how to get last 30 days(not month) records in SQL server query.
Currently, I am using SQL server 2012.
...Hello, I can across a question earlier today while working at the office and would like to know if sql server management studio is free to use or we need to pay for it?
...