SQL Language
This section describes SQL statements and syntaxes.

Articles

  • Deepak Middha

    Cursor In SQL Server

    This article describes cursors, declaration of cursors, opening of cursors, fetching from cursors, closing of cursors and deallocating cursors.
    Deepak Middha Oct 20, 2012
  • Mohamed Elqassas Mvp

    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
  • 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 May 21, 2013
  • 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 07, 2013
  • 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 May 16, 2015
  • 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 Oct 22, 2012
  • 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 Oct 17, 2012
  • 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 Feb 17, 2011
  • 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 Nov 16, 2011
  • Jignesh Trivedi

    SQL Injection In Dynamic SQL

    In this article you will learn about SQL Injection in Dynamic SQL.
    Jignesh Trivedi Apr 17, 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.
  • Kailash Chandra Behera

    SQL Transaction Overview

    This article describes about Sql transaction with example in SQL language as well as ADO.NET.
  • SANTHOSH KUMAR

    SQL Basics Overview

    In this article you will learn about SQL basics.
    SANTHOSH KUMAR Oct 24, 2015
  • Pankaj  Kumar Choudhary

    SQL Basic Queries

    In this article I will explain some basic SQL queries.
  • Amol Jadhao

    Difference between Output Parameter and Return Value in Stored Procedure

    This article will help you to understand the difference between output parameter and return value in a Stored Procedure.
    Amol Jadhao Aug 26, 2015
  • Jitendra Kumar

    Some Simple and Important SQL Server Query Based Interview Questions

    In this article I explain some important SQL query qustions that are commonly asked when you go for an interview for a position requiring one to three years of experience in this field.
    Jitendra Kumar Dec 07, 2014
  • View More
    X

    Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

    Start Learning Now