SQL

1116 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

1057 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

1022 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

842 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

812 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

791 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

763 0

How to back up SQL Server database?

Article explains various ways to backup SQL Server using C#, Powershell, by generating scripts or writing a script

Type
Article

C# SQL Back-up Database

722 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

661 0

Top SQL tips for beginners (a must read)

Article give details about SQL, tips, and tricks for beginners

Type
Article

sql performance tips

563 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

Page 1 of 4