3326 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
3301 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
2544 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
2384 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
2246 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

2156 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
2114 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
2090 1
How to open sql server configuration manager in windows 10?

I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks

...
Type
Question
SQL sql server configuration manager in windows 10
1995 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
SQL stored procedure in sql server stored procedure in sql sql create stored procedure sql server procedure
1949 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

Page 1 of 5