SQL

1595 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

1521 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

1330 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

1080 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

1013 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

980 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

936 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

933 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

858 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

801 0

Top SQL tips for beginners (a must read)

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

Type
Article

sql performance tips

Page 1 of 5