SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • 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
  • Sibeesh Venu

    SQL Server Tips and Tricks

    This article provides some tricks we may use in our day-to-day programming life in SQL.
    Sibeesh Venu Jun 29, 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.
  • Pankaj  Kumar Choudhary

    Execution Order of Triggers In SQL

    This article explains the execution order of triggers In SQL.
  • Rakesh

    Functions in SQL Server Databases

    This article explains how functions work in SQL Server databases.
    Rakesh Jun 20, 2015
  • Pankaj  Kumar Choudhary

    What Case Expressions in SQL Are

    This article explains Case Expressions in the SQL language with examples.
  • Pankaj  Kumar Choudhary

    Tips to Increase SQL Server Query Performance: Part 2

    This article provides more tips to increase SQL Server query performance.
  • Pankaj  Kumar Choudhary

    Tips to Increase SQL Server Query Performance: Part 1

    In this article we will learn how to increase the query performance in SQL Server.
  • Pankaj  Kumar Choudhary

    Naming Conventions in SQL

    In this article we learn about naming conventions for all objects that are mainly used in SQL.
  • Pankaj  Kumar Choudhary

    Important Queries in SQL

    In this article we learn some interesting and useful SQL queries.
  • Pankaj  Kumar Choudhary

    Cursors in SQL

    In this article we willl learn about Cursors with example.
  • Pankaj  Kumar Choudhary

    Triggers in SQL

    This article explains the various types of triggers.
  • Rakesh

    Getting Started With Basic SQL Keywords And SQL Join

    In this article you will be learning about the basic keywords of the SQL Language.
    Rakesh Jun 01, 2015
  • Rasmita Dash

    Interview Questions For 2 Years Experience in SQL and C#

    This article provides answers interview questions for 2 years experience in SQL and C#.
    Rasmita Dash May 29, 2015
  • Vijay  Prativadi

    Interactive Sorting For SSRS Report

    This article shows how to use interactive sorting for a SSRS report.
    Vijay Prativadi May 27, 2015
  • Vijay  Prativadi

    SSRS Report Using Stored Procedure

    This article shows you how to use a Stored Procedure for a SSRS report.
    Vijay Prativadi May 26, 2015
  • Pankaj  Kumar Choudhary

    Constraints in SQL Server

    Here you will learn about constraints in SQL Server with examples.
  • Durgaprasad Yadav

    Index in SQL SERVER

    This article provides a simple definition of indexes, their types, how to create them and the difference between clustered and non- clustered indexes.
    Durgaprasad Yadav May 20, 2015
  • 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
  • Emiliano Musso

    Search For Missing Values Within a Numerical Sequence

    The purpose of this short article is to show a method for identifying, within a SQL Server table, gaps in a numerical sequence, to quickly locate absences of consequence within given data.
    Emiliano Musso May 18, 2015
  • Emiliano Musso

    Examples Of DATE/DATETIME Conversion

    Basic considerations and examples of DATETIME, DATE and TIME data types.
    Emiliano Musso May 15, 2015
  • Pankaj  Kumar Choudhary

    System Views in SQL

    Views are very important and useful features of SQL. Let's learn what views are exactly.
  • Akshay Phadke

    Important Facts About MySQL Server

    In this article we will learn some of the important facts about MySQL Server.
    Akshay Phadke May 04, 2015
  • Rakesh

    SQL Server Database Basics Query Command

    This article provides some SQL Server database basic information including database creation, data table creation and basic query information.
    Rakesh May 03, 2015
  • Krishnanand Sivaraj

    Creating Cubes in SSAS

    In this article we will learn about Server Analysis Services (SSAS).