66 1
How to find missing date between two dates in sql table.

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’.

 

...
Type
Question
sql date sql-server
4 0
How to find missing date in sql table.

I have data like this,

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 query which is return missing dates from date column like  ‘2018-1-11’ , ‘2018-1-14’.

 

...
Type
Question
sql date
21 1
Pseudo code in SQL

I have to write a pseudocode program to read the two sample files, calculate and print the final mark for each subject, as well as the average final mark per student.

Document the code well using comments.

The final mark is calculated as 25% of the year mark, 25% of the prac mark and 50% of the exam mark.

Assume the records of the two files are arranged in Student number (S-no) sequence. Note that some students have more subjects than others….

 

I was tasked with the above program and im not sure how to express this in pseudo code.

 

...
Type
Question
SQL Pseudo
1204 0
How to back up SQL Server database ? (Various Ways explained)
This article explains various ways to backup SQL Server database using C#, using Powershell script, by generating scripts in SQL server or writing a script.
Type
Article
C# SQL sql server backup database backup sql server
648 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
SQL stored procedure in sql server stored procedure in sql sql create stored procedure sql server procedure

64 1
Get sum from three table and selected data using SQL

Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.

Suppose here are my tables

Table 1: raw_item_fcst

sql-table-fetch-data-from-three-tables-min.png


Table 2. Raw_item

table-2-min.png

Table 3 . inventory_data

table-3-min.png

I try to write query to fetch data from these tables using subquery , Here is my sub query

...
Type
Question
SQL Sum-of-three-columns data-from-three-columns-sql
62 1
I have deleted my database by accidentially in sql server 2017 is there is any way to recover it?

Hi, I have deleted my database by accidentially in sql server 2017 is there is any way to recover it? Thanks.

...
Type
Question
SQL recover-deleted-database
549 0
SQL server connection string examples in C# & XML
In this article, I have provided various examples of SQL server connection string in C#, ASP.NET Web.Config file in XML format and MySQL connection string in C#.
Type
Article
C# SQL-server-connection-string sql-server-connection-string-c# sql-server-connection-string-integrated-security c#-database-connection
281 1
Sum of two column values from two different tables

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

...
Type
Question
sql sql server
323 0
How to fix "SQL server configuration manager cannot connect to wmi provider" error?
In this article, I am going to provide your easy way to fix SQL server configuration manager cannot connect to wmi provider error.
Type
Article
SQL SQL server sql server configuration manager cannot connect to wmi provider

Page 1 of 5