SQL Language
This section describes SQL statements and syntaxes.

Blogs

  • 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
  • Pramod Thakur

    User Defined Function in SQL

    In this blog we learn basic functions of SQL.
    Pramod Thakur Mar 31, 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
  • Ashutosh Mund

    Parsing XML Data from SQL Database Column

    In this blog you will learn how to Parsing XML Data from SQL Database Column.
    Ashutosh Mund Nov 28, 2015
  • Gowtham K

    Convert Data Table to XML in SQL Server

    From this blog we will learn how to convert the data table to XML using XML Raw, XML path, XML Auto.
    Gowtham K Aug 30, 2015
  • Deepak Kumar Choudhary

    Introducing Trigger

    In this blog you will learn about Trigger.
  • Gowtham K

    Calling/Executing SQL Stored Procedure from Another Stored Procedure

    In this blog I will explain one of the major application in stored procedure that is executing/calling one procedure from another procedure with parameters.
    Gowtham K Aug 19, 2015
  • Rakesh Kalluri

    Restrict SP_ (Naming convention) using DDL Trigger

    In this blog you will learn about Restrict SP_ (Naming convention) using DDL Trigger.
    Rakesh Kalluri Jul 14, 2015
  • Govinda Rajulu Yemineni

    SET vs. SELECT when assigning values to variables

    In this blog we will see the difference between SET and SELECT while assigning values to variables.
  • Rakesh Kalluri

    Difference between COUNT and COUNT_BIG in SQL

    In this blog you will learn Difference between COUNT and COUNT_BIG in SQL.
    Rakesh Kalluri Jul 13, 2015
  • Rakesh Kalluri

    Foreign Key with Delete CASCADE in SQL

    in this blog you will learn Foreign Key with Delete CASCADE in SQL.
    Rakesh Kalluri Jul 06, 2015
  • Sujeet Suman

    DATEFORMAT and ISDATE Command in SQL

    In this blog you will learn DATEFORMAT and ISDATE Command in SQL language.
    Sujeet Suman Jul 03, 2015
  • Pankaj  Kumar Choudhary

    Single Stored Procedure For DML Queries

    In this blog we will learn how to create a single stored procedure for all DML queries.
  • Emiliano Musso

    Retrieve Table List with Number of Rows

    In this blog, you will see a quick way to list tables with number of rows in a database.
    Emiliano Musso May 19, 2015
  • Kml Surani

    Creating a Dynamic Table In SQL Server

    This blog describes creating a dynamic table name and Alter Table of User Registration Form
    Kml Surani Apr 16, 2015
  • Debendra Dash

    Binding Events in a Calender From DataBase

    In this blog we will learn Binding Events in a Calender From DataBase.
    Debendra Dash Apr 05, 2015
  • Nitin

    Finding nth highest salary from a table

    In this blog we will see how to find the nth highest salary from a given table.
    Nitin Apr 03, 2015
  • View More