1790 0
Aggregate Functions in SQL Server (SUM, AVG, COUNT, MIN, MAX)
This article provides you complete details of the aggregate function (SUM, AVG, COUNT, MIN, MAX) in SQL server with suitable examples.
Type
Article
SQL AGGREGATE Functions SUM AVG COUNT
1663 0
Understanding SQL server switch case (With Example)
This article provides you implementation details of SQL server switch case statement and how to use it with examples
Type
Article
SQL SQL server sql server case statement
1477 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
SQL sql-server insufficient-memory cannot-execute-script
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
1170 2
How to use switch case statement in stored procedure?

As easily we use the if else statement in stored procedure to check the statement type and there after we perform the desired task. Same thing I want to do using switch case 

...
Type
Question
Switch case in sql procedure Switch case SQL

1145 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
SQL Stored procedure function sql server
1018 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
SQL with in sql SQL With example
1013 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
asp.net exception sql exception stored-procedure
985 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
sql where negate select where id is not equal to
896 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
SQL exception-mscorlib

Page 1 of 5