2750 0
Difference between Stored procedure and function in SQL Server (Lists differences and explains each of them separately.)
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
2737 1
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
2676 0
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
2433 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
2265 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

2228 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
2047 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
1856 2
Getting error 'A transport-level error has occurred when receiving results from the server.'

When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

...

Type
Question
1762 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
1758 2
Could not find stored procedure

I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"

 

...
Type
Question

Page 2 of 6