5085 2
Where can I download SQL server 2016 express full?

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

...
Type
Question
4756 0
How to check sql server version? (Various ways explained)
In this article, I am going to provide you various possible ways to check SQL server version, by following these simple steps.
Type
Article
4725 1
Cannot execute script: Insufficient memory Error in SQL server

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

...

Type
Question
4199 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
4168 0
WITH in SQL (Examples included using SQL server)
This article explains you about WITH clause in SQL and when to use it with few example's
Type
Article

4110 2
SQL server 2012 - Error: attempted to read or write protected memory

When I am trying to Edit my tables on my newly installed SQL server management studio, I am getting the error below

Exception has been thrown by the target of an invocation. (mscorlib)
 Additional information:
   Attempted to read or write protected memory. This is often an indication that 
   other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)

Here is the image of the error

...

Type
Question
3855 1
SQL server date format and converting it (Various examples)
This article provides you in-depth knowledge of SQL server date format available and how to convert from one date format to other using examples
Type
Article
3668 0
Difference between Stored procedure and function in SQL Server
This article, lists important difference difference between Stored procedure and function in SQL Server after giving brief details about Stored procedures and functions (user-defined functions) in SQL server.
Type
Article
3401 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
3344 1
how to select row where Id is not equal to in SQL?

I want to select rows from a table where Id is not equal to 4, How to achieve it using SQL query?

Something like in C# .Where(a=>a.Id != 4).ToList() ?

Or in SQL like Select * Where Id != 4?

Thanks

...
Type
Question

Page 2 of 6