SQL

3081 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

2624 0

SQL server connection string examples in C# & XML

In this article, I have provided various examples of SQL server connection string in C#, ASP.NET Web.Config file in XML format and MySQL connection string in C#.

Type
Article

C# SQL-server-connection-string sql-server-connection-string-c# sql-server-connection-string-integrated-security c#-database-connection

2401 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

2113 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

2100 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

2026 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

1893 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

1776 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

Need offline installer, thanks

...

Type
Question

SQL-Server-2016 sql express 2016 offline installer sql express 2016 management studio

1761 0

Restore (Import) database from .bak file in SQL server (With & without scripts)

In this short article, I am giving steps with images to restore database from .bak file in SQL server & I have also explained ways in sql server to restore database from bak file using script.

Type
Article

SQL restore database using .bak sql server sql restore database from bak file script

1750 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