C# Corner

In this article we will learn about Common Table Expressions (CTE) in SQL SERVER 2008.

This article explains triggers in SQL Server. A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, delete and update) o...

In this article I describe triggers. A Trigger is a Database object just like a stored procedure or we can say it is a special kind of Stored Procedure which fires when an event occurs in a database.

In this article, we will learn about Cursors with example. A SQL cursor is a temporary work area created in system memory when an SQL statement is executed. A cursor is a set of rows together with ...

This article describes cursors, declaration of cursors, opening of cursors, fetching from cursors, closing of cursors and deallocating cursors.

In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL

In this blog, You will see Row_Number function without Partition By or with Partition By clause.

In this article, I will demonstrate how can we call stored procedure from entity framework? There are many different way to call stored procedure from entity framework.

How to use a database to find nearby locations. The geography data type and associated SQL Server functions can be used to calculate distances and search for nearby locations.

In this article, I describe Views in SQL Server. Views are database objects which are like virtual tables that have no physical storage and contains data from one table or multiple tables.

Here you will see how to use SQL Executer. The article is written for beginners, the methods to communicate with database are kept simple.

Here, we will see how to create select, insert, update, delete statements using stored procedure.

In this blog, you will learn about the basic types of SQL statements with examples.

This blog shows us, how to create a trigger in SQL Server for the beginner level.

In this blog we learn how get day name of week for given date.

How to find Nth highest and lowest salary in SQL.

In this article you will learn about SQL Injection in Dynamic SQL.

In this blog we learn basic functions of SQL.

This blog is about the Top keyword in SQL and it's use.

Today, we are pleased to announce one more ebook to the collection of C# Corner free books library, Basic SQL Queries. Basic SQL Queries book is written by C# Corner authors Kamal Rawat & Akshay Pa...

Devart presents LINQ Insight - a powerful Visual Studio add-in which allows developers to execute LINQ queries right from the code at design time, thus making creating and debugging LINQ queries mu...

Devart released a new version of dbForge SQL Complete with SQL Refactoring, Code Highlighting and other new features.

This article will help you to learn the WHERE clause and expressions used with it.

In this article you will learn DataTableAdapter Design Technique using DataSet.

This article will help you to learn about SELECT Statement in SQL.