SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • M.Qassas

    T-SQL - Retrieve Task Hierarchy In Project Server

    In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
    M.Qassas Oct 12, 2017
  • Rohatash Kumar

    Row_Number Function With PARTITION BY Clause In SQL Server

    In this blog, You will see Row_Number function without Partition By or with Partition By clause.
    Rohatash Kumar Aug 01, 2017
  • Jignesh Trivedi

    Call Stored Procedure From Entity Framework

    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.
    Jignesh Trivedi Jul 13, 2017
  • Andrew Fenster

    How To Find A Doctor Near Your Home in SQL Server

    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.
    Andrew Fenster Jun 27, 2017
  • Durgaprasad Yadav

    Triggers in SQL Server

    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...
    Durgaprasad Yadav Jun 26, 2017
  • Deepak Middha

    View in SQL Server

    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.
    Deepak Middha Jun 23, 2017
  • Deepak Middha

    Triggers in Sql Server

    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.
    Deepak Middha Jun 23, 2017
  • abdur rehman

    SQL Executer

    Here you will see how to use SQL Executer. The article is written for beginners, the methods to communicate with database are kept simple.
    abdur rehman Jun 22, 2017
  • Rohatash Kumar

    Select, Insert, Update, Delete Using Stored Procedure in SQL Server 2008

    Here, we will see how to create select, insert, update, delete statements using stored procedure.
    Rohatash Kumar May 31, 2017
  • Manoj Kumar

    Types Of SQL Statements With Examples

    In this blog, you will learn about the basic types of SQL statements with examples.
    Manoj Kumar Jan 03, 2017
  • Gaurav Gohel

    Triggers in SQL Server

    This blog shows us, how to create a trigger in SQL Server for the beginner level.
    Gaurav Gohel Aug 05, 2016
  • Pankaj  Kumar Choudhary

    Get Day of Week in SQL Server

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

    How to find Nth highest and lowest salary in SQL

    How to find Nth highest and lowest salary in SQL.
    Gaurav Kumar Jul 19, 2016
  • Jignesh Trivedi

    SQL Injection In Dynamic SQL

    In this article you will learn about SQL Injection in Dynamic SQL.
    Jignesh Trivedi Apr 18, 2016
  • Pramod Thakur

    User Defined Function in SQL

    In this blog we learn basic functions of SQL.
    Pramod Thakur Apr 01, 2016
  • Jainish Shah

    Top Keyword in SQL

    This blog is about the Top keyword in SQL and it's use.
    Jainish Shah Mar 19, 2016
  • Praveen Moosad

    Basic SQL Queries Book Available Now

    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...
    Praveen Moosad Feb 21, 2016
  • Devart

    Debug LINQ Easily - Execute LINQ Queries at Design-time with LINQ Insight

    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 Feb 21, 2016
  • Devart

    Devart Released dbForge SQL Complete 5.0

    Devart released a new version of dbForge SQL Complete with SQL Refactoring, Code Highlighting and other new features.
    Devart Feb 21, 2016
  • Jainish Shah

    SQL For Beginners - WHERE Clause

    This article will help you to learn the WHERE clause and expressions used with it.
    Jainish Shah Jan 09, 2016
  • Maruthi Palllamalli

    DataTableAdapter Design Technique Using DataSet

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

    SQL For Beginners - SELECT Statement

    This article will help you to learn about SELECT Statement in SQL.
    Jainish Shah Jan 06, 2016
  • Jainish Shah

    SQL For Beginners - Introduction

    This article will help you to learn SQL from scratch.
    Jainish Shah Jan 04, 2016
  • Pankaj  Kumar Choudhary

    Types Of Keys In Database

    In this article you will learn about different types of keys in database.
  • Sivaraman Dhamodaran

    Using the In-Line Table-Valued Function

    This video shows how one can use the In-Line function that returns a table.
  • View More